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

179 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
tzarist165910(None) 
czarist18710221czarist
tsarist7712251tsarist
tzarism1866321tzarism
tzarists1755691tzarists
czarism2056422czarism
czarists1966222czarists
diarist8517112diarist
tanist6324602t_anist
teariest82417262teariest
tourist7313202tourist
tsarism958252tsarism
tsarists857302tsarists
tzarina1635052tzarina
tzarisms1965212tzarisms
tzars144914272tzar_s_
tzuris15286912tzuris_
agist66325583__agist
alarmist1049123alarmist
alist56136783__alist
amorist9317643amorist
aorist64827873_aorist
apiarist10412063apiarist
aquarist171010083aquarist
arise56436433__arise
arista6415293__arista
aristo6414033__aristo
artist64125543__artist
atavist10311093atavist
aurist65027253_aurist
aviarist11410113aviarist
barest85327693_barest
barista9310813_barista
bearish123013273bearish
boarish123911913boarish
chariest13315513chariest
chariot12316213chariot
charism14712203charism
chartist131112133chartist
cladist10311973cladist
czarina1845953czarina
czarisms2155753czarisms
czars164812913czar_s_
dearest83618673dearest
dialist8517763dialist
diarists9410363diarists
dualist8614053dualist
etatist7415033etatist
florist10314243florist
garish104516923_garish
glariest92012533glariest
grist65529873__grist
harpist12312363_harpist
hoariest11312883hoariest
imagist1077333imagist
izars145112933izar_s_
jurist134616393_jurist
karst97228993_kar_st
lariat6629043_lariat
laris54737463_laris_
leariest83117853leariest
lyrist9312293_lyrist
maist75535683_ma_ist
marish114319053_marish
metrist9317063metrist
narcist9512443_narcist
naris55735293_naris_
nearest73415843nearest
onanist7314633onanist
oralist7619633oralist
papist102618753_papist
paris75145943_paris_
parish115022353_parish
pianist9615103pianist
purist85525053_purist
querist16311133querist
racist82822793_racist
rapist82520673_rapist
rarest65725483_rarest
realist73225383realist
sacrist9315423sacrist
sadist74221353_sadist
saris54544953_saris_
scariest101615953scariest
searest73322023searest
sitarist8315283sitarist
sparest94616433sparest
statist7317723statist
tachist12613293tachist
tacit76333673t_aci_t
taint55542283t_a_int
tamaris9413603tamaris_
tamarisk1445473tamarisk
tamest85721293t_amest
tamis76728733t_amis_
tanists7313653t_anists
tapis75028863t_apis_
tardiest93515243t_ardiest
tares57456563t_ares_
target75028913t_arget
tariff12711363t_ariff
taring73932283t_aring
tarnish101611873t_arnish
tarns56433953t_arns_
taros55640823t_aros_
tarot55943933t_ar_ot
tarots66422993t_arots
tarps76527123t_arps_
tarriest83215003tarriest
tars46763953t_ar_s_
tarsi55222173t_ar_si
tarsia65514273t_arsia
tart47566183t_ar__t
tartest72517533t_artest
tartiest82718313t_artiest
tartish101512633t_artish
tarts57242023t_arts_
taxis126821973t_axis_
tearier73815613tearier
tearily10311153tearily
tearing84021493tearing
tears55436463tear_s_
tennist72813113tennist
tenorist8413023tenorist
terais64023513terais_
territ63421373terri_t
territs72714503territs
tetris62816293tetris_
tharms115712243tharms_
theist9314763t_heist
theorist1149553theorist
thirst9312253thir_st
thrift12412043t_hrift
thrust91911893t_hrust
tiaras6314553tiaras_
tigrish1137573tigrish
titlist7312923titlist
toadish1139063toadish
toast55831013toa__st
totalist8315583totalist
tourism939423tourism
tourista844403tourista
tourists838313tourists
touristy1144513touristy
tovarish1445123tovarish
trait56940843tra_i_t
traits65121983tra_its
transit7317163transit
triste63818643t__riste
trust55426853t__rust
tryst84716223t__ryst
tsadis7429133tsadis_
tsarina736653tsarina
tsarisms1056653tsarisms
tsars56717113tsar_s_
tsoris63411193tsoris_
tsuris62710203tsuris_
tubaist938703tubaist
tubist83013163t_ubist
turista737443t_urista
twist86820983t__wist
typist1139823t_ypist
tzar136315373tzar___
tzardom1943733tzardom
tzarinas1733973tzarinas
tzaritza1681673tzaritza
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.406440125.6
2DLD Change Limit1340271796.83019623.3
3Display Results1791790.0602983.3
 (SQL Overall)1786911797.29624491.6
 
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.