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 “czarist” 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.

222 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
czarist1871022(None) 
czarism2056421czarism
czarists1966221czarists
tzarist1659101tzarist
chariest13315512chariest
chariot12316212chariot
charism14712202charism
chartist131112132chartist
cladist10311972cladist
czarina1845952czarina
czarisms2155752czarisms
czars164812912czar_s_
diarist8517112diarist
tsarist7712252tsarist
tzarism1866322tzarism
tzarists1755692tzarists
agist66325583__agist
alarmist1049123alarmist
alist56136783__alist
amorist9317643amorist
aorist64827873_aorist
apiarist10412063apiarist
aquarist171010083aquarist
arise56436433__arise
arista6415293__arista
aristo6414043__aristo
artist64125543__artist
atavist10311093atavist
aurist65027253_aurist
aviarist11410123aviarist
barest85327693_barest
barista9310823_barista
bearish123013273bearish
boarish123911913boarish
cabalist12314503cabalist
cadis84428503c_adis_
cagiest102916433c_agiest
cakiest133215663c_akiest
cambist13312113cambist
camisa103114323c_amisa
camise103319633c_amise
canst74932213c_a_nst
capris10415083capris_
carat75048803c_ar_at
carats85929023c_arats
carbs96031463c_arbs_
cards85137933c_ards_
cares77369183c_ares_
caress85720263c_aress
caret75360563c_ar_et
carets85330773c_arets
caribe103416753c_aribe
caried94528693c_aried
caries85147623c_aries
carina84325333c_arina
caring95137993c_aring
carks115534213c_arks_
carlish12312773c_arlish
carls77037423c_arls_
carnet84732873c_arnet
carns75937563c_arns_
carpet104530093c_arpet
carps96932253c_arps_
carrot8423123c_arrot
carrs75730853c_arrs_
cars67364763c_ar_s_
carse74934333c_ar_se
cart66570343c_ar__t
carts78946293c_arts_
cast67159903c_a__st
casuist9411303casuist
cellist9314423cellist
centrist10314863centrist
ceramist12310933ceramist
cerise84822043c_erise
chairs114916183chairs_
chais107530313cha_is_
chaise114916413cha_ise
chamisa14328853chamisa
chamise143612853chamise
chamiso14348653chamiso
charas114223613charas_
chards125119733chards_
chares115631803chares_
charier124317903charier
charily15310283charily
charing133721323charing
chariots1339393chariots
charisma1576363charisma
charisms15710263charisms
charity15311023charity
charks155219703charks_
charms135218843charms_
charriest1438263charriest
charrs115219193charrs_
chars105936643char_s_
chart105038283char__t
chartists14126803chartists
charts115823093charts_
chemist143615003chemist
cherish15310463cherish
chrism13710673c_hrism
christy1536623c_hristy
chutist1239453chutist
chymist17268173chymist
cist67244973c___ist
cladism1238553cladism
cladists1136723cladists
claret84026573clar_et
clarets94111103clarets
claries93422203claries
clarify1536093clarify
clarinet10317293clarinet
clarion9311663clarion
clarity12310913clarity
claros84015113claros_
classist104010383classist
clast76030583cla__st
clayiest1337923clayiest
clayish1547943clayish
clearest1038653clearest
clerisy1246823clerisy
coaliest10316223coaliest
coarse84813903coar_se
coarsest1039163coarsest
coassist10298803coassist
coast75236273coa__st
coatis85122603coatis_
coexist1638583coexist
colorist102818993colorist
consist9316033consist
copyist1439053copyist
cosmist11311333cosmist
crasis85020473crasis_
craziest19319923craziest
crest74632693c__rest
cris66233433c__ris_
crisp95014623c__risp
crista8311803c__rista
crit65743713c__ri_t
crits75527573c__rits
crust75827663c__rust
cubist104214443c_ubist
cultist91412713cultist
curaris94114773curaris_
currish1238353currish
curst74931023c_ur_st
cyclist1438853cyclist
czar156013133czar___
czardas1934673czardas
czardom2144183czardom
czarinas1935303czarinas
czaritza1891953czaritza
dearest83618673dearest
dialist8517763dialist
diarists9410363diarists
dualist8614053dualist
etatist7415033etatist
florist10314243florist
garish104516933_garish
glariest92012533glariest
grist65529873__grist
harpist12312363_harpist
hoariest11312883hoariest
imagist1077333imagist
izars145112933izar_s_
jurist134616393_jurist
karst97229003_kar_st
lariat6629053_lariat
laris54737463_laris_
leariest83117853leariest
lyrist9312293_lyrist
maist75535683_ma_ist
marish114319063_marish
metrist9317063metrist
narcist9512443_narcist
naris55735293_naris_
nearest73415843nearest
ocularist1177323ocularist
onanist7314633onanist
oralist7619633oralist
papist102618753_papist
paris75145943_paris_
parish115022363_parish
pianist9615103pianist
purist85525053_purist
querist16311133querist
racist82822793_racist
rapist82520673_rapist
rarest65725483_rarest
realist73225383realist
sacrist9315423sacrist
sadist74221353_sadist
saris54544953_saris_
scariest101615953scariest
scenarist1147823scenarist
searest73322023searest
sitarist8315283sitarist
sparest94616433sparest
statist7317723statist
tanist6324613_tanist
teariest82417263teariest
tourist7313203tourist
tsarism958253tsarism
tsarists857303tsarists
tzarina1635053tzarina
tzarisms1965213tzarisms
tzars144914273tzar_s_
tzuris15286913tzuris_
uraris63817273uraris_
verist93823893_verist
votarist111012163votarist
waist86132383_wa_ist
wariest105122503_wariest
weariest112914793weariest
wearish132310153wearish
wrist84827563__wrist
yarest95018913_yarest
zaniest163214773_zaniest
zarfs174713623_zarfs_
zariba1736983_zariba
zoris145320013_zoris_

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272227.04619021.7
3Display Results2222220.0802775.0
 (SQL Overall)1786912227.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.