Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “czarinas” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

148 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
czarinas193529(None) 
carinas93622401c_arinas
czarina1845951czarina_
tzarinas1733971tzarinas
carina84325322c_arina_
carinae94318582c_arinae
carinal94318232c_arinal
caritas93316952c_aritas
czardas1934672czar_das
czarevnas2341352czarevnas
czarisms2155752czarisms
czarists1966222czarists
czaritzas1991642czaritzas
farinas103215232_farinas
jarinas143712182_jarinas
marinas93519382_marinas
ocarinas1036722ocarinas
tsarinas835272tsarinas
tzarina1635052tzarina_
zaribas1836042_zaribas
acarines10314343acarines
arenas65021993__arenas
arias55438023__ari_as
bearings113912253bearings
cabanas112413033c_abanas
cabins104418923c_abin_s
cains75334303c_a_in_s
cairns85313303c_airn_s
camisas113411923c_amisas
canines93724033c_anines
cannas84518403c_a_nnas
cantinas102713773cantinas
capias10318353c_api_as
carbines123617533c_arbines
cardias10715113c_ardias
cardinal1139563c_ardinal
cardinals1247993c_ardinals
cardings123812633c_ardings
caribes113715643c_aribes
carices114220953c_arices
caries85147623c_ari_es
carinate103320243c_arinate
caring95137993c_arin_g
cariocas1239663c_ariocas
carious93320283c_arious
carlines103521643c_arlines
carlings114015853c_arlings
carlins93921913c_arlin_s
carmines123617863c_armines
carnal83919203c_ar_nal
carnies94123963c_arnies
carns75937563c_ar_n_s
carpings133812383c_arpings
carvings143810203c_arvings
casings104013513c_asings
casinos93512833c_asinos
casitas93312043c_asitas
cassinas103610633cassinas
casuarinas1243043casuarinas
catenas9313113c_atenas
cavatinas1444783cavatinas
cavings134712543c_avings
cerias83321983c_eri_as
cesarians1146363cesarians
chagrins1437073chagrin_s
chaines124518733cha_ines
chains114819703cha_in_s
chamisas15317813chamisas
charas114223613char__as
chariness14310063chariness
charing133721323charin_g
chariots1339393chariots
charismas1655313charismas
charisms15710263charisms
charkas164810963char_kas
charkhas20285023charkhas
chasings14318253chasings
chinas115119403c__hinas
chorines132917253chorines
citrines102513133citrines
citrins92614363citrin_s
claries93422203clari_es
clarinet10317293clarinet
clarinets1137683clarinets
clarions10310493clarions
clarkias1444793clarkias
clearings12286063clearings
coamings13349293coamings
coatings113811843coatings
codeinas11338023codeinas
coquinas1944783coquinas
corbinas12229393corbinas
coronas93916913c_oronas
corridas1177313corridas
cortinas102212443cortinas
corvinas13238013corvinas
cravings14428223cravings
cumarins1238643cumarin_s
curarines11710553curarines
cyanines132710543cyanines
cyanins122910013cyanin_s
cyprians1544213cyprians
czardoms2243743czardoms
czarevna2241253czarevna_
czarism2056423czari_sm
czarist18710223czari_st
czaritza1891953czaritza
czars164812913czar___s
darings93713653_darings
dharnas1155373dhar_nas
earings84517713_earings
farina94618233_farina_
farinhas14325363_farinhas
gearings10359503gearings
guaranas995943guaranas
harianas1139163_harianas
hearings123611853hearings
jarina134014063_jarina_
laminas93615873_laminas
latinas74416463_latinas
marina84623413_marina_
marines93928013_marines
ocarina948033ocarina_
parians93519733_parians
parings104219213_parings
patinas96318523_patinas
platinas103610313platinas
roarings9248293roarings
salinas73116093_salinas
sarcinas1039273_sarcinas
sarins63932623_sarin_s
sharias102516003shari_as
soarings93210393soarings
spartinas1135793spartinas
staminas1048853staminas
tsarina736653tsarina_
tzarevnas215953tzarevnas
tzarisms1965213tzarisms
tzarists1755693tzarists
tzaritzas1791253tzaritzas
vaginas11298813_vaginas
varias95019903_vari_as
varnas94212823_var_nas
zamias174212923_zami_as
zananas16319563_zananas
zarebas1836303_zarebas
zariba1736983_zariba_
zayins18409713_zayin_s

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1561145455.1
2DLD Change Limit1461621488.89016441.2
3Display Results1481480.436339.4
 (SQL Overall)1786911489.48218845.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.