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

250 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
tsarist771225(None) 
tsarism958251tsarism
tsarists857301tsarists
tzarist1659101tzarist
czarist18710222czarist
diarist8517112diarist
sacrist9315422_sacrist
sadist74221352_sadist
saris54544952_saris_
statist7317722statist
tanist6324592t_anist
teariest82417262teariest
tourist7313202tourist
tsadis7429132tsadis_
tsarina736652tsarina
tsarisms1056652tsarisms
tsars56717112tsar_s_
tsoris63411192tsoris_
tsuris62710202tsuris_
tzarism1866322tzarism
tzarists1755692tzarists
agist66325583__agist
alarmist1049123alarmist
alist56136783__alist
amorist9317643amorist
aorist64827873_aorist
apiarist10412063apiarist
aquarist171010083aquarist
arise56436433__arise
arista6415293__arista
aristo6414033__aristo
artist64125543__artist
ascaris93613323ascaris_
assist6314603as_sist
astrict9614793astrict
atavist10311093atavist
aurist65027253_aurist
aviarist11410113aviarist
barest85327693_barest
barista9310813_barista
bassist9312743bassist
bearish123013273bearish
boarish123911913boarish
casuist9411303casuist
chariest13315513chariest
chariot12316213chariot
charism14712203charism
chartist131112133chartist
cladist10311973cladist
czarism2056423czarism
czarists1966223czarists
dearest83618673dearest
dialist8517763dialist
diarists9410363diarists
dualist8614053dualist
escapist1246213escapist
esprit8312843espri_t
esprits938393esprits
essayist1143623essayist
etatist7415033etatist
fascist1239213fascist
florist10314243florist
garish104516923_garish
glariest92012533glariest
grist65529873__grist
harpist12312363_harpist
hoariest11312883hoariest
imagist1077333imagist
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
psalmist1276353psalmist
purist85525053_purist
querist16311133querist
racist82822793_racist
rapist82520673_rapist
rarest65725483_rarest
realist73225383realist
sacrists1039563_sacrists
sacristy1345103_sacristy
sadis64930853_sadis_
sadism94113493_sadism
sadists83310853_sadists
safest95016603_safest
sagest74920263_sagest
sagiest82617993_sagiest
saint55147073_sa_int
sakis95323673_sakis_
sanest64426693_sanest
sards64736183_sards_
sari45444043_sari__
sarin55239253_sari_n
sarins63932623_sarins
sarkiest123615073_sarkiest
sarks96632463_sarks_
sarodist9510923_sarodist
saros55238063_saros_
satirist8313503_satirist
satis55633683_satis_
sayest94217743_sayest
sayst85322003_sa_yst
scariest101615953scariest
schist11312653_schist
script105717903_script
searest73322023searest
serest64831613_serest
sexist133013483_sexist
shist84829613_s_hist
shrift12413543_shrift
shris84221453_shris_
sitarist8315283sitarist
sorest65028003_sorest
sparest94616433sparest
spriest92718653_spriest
sprint84526793_sprint
sprit76736403_spri_t
sprits85122533_sprits
sris45434153_s_ris_
stagiest91613413stagiest
stairs65416333stairs_
stalest73720173stalest
stardust946093stardust
stares66038753stares_
starets73515923starets
starfish1438083starfish
staring84527053staring
starkest1239723starkest
starlet71620123starlet
starlit71512913starlit
starriest9159773starriest
stars55836573star_s_
start55642313star__t
starts65423123starts_
startsy10536703startsy
stasis63116873stasis_
statism9412283statism
statists8310163statists
strait64025893strai_t
straits74916323straits
strict84821043_strict
stript85222193_stript
stylist102110283stylist
surest65026763_surest
tachist12613293tachist
tacit76333673t_aci_t
taint55542283t_a_int
tamaris9413603tamaris_
tamarisk1445473tamarisk
tamest85721293t_amest
tamis76728733t_amis_
tanists7313653t_anists
tapis75028863t_apis_
tardiest93515243t_ardiest
tares57456563t_ares_
target75028903t_arget
tariff12711363t_ariff
taring73932283t_aring
tarnish101611873t_arnish
tarns56433953t_arns_
taros55640823t_aros_
tarot55943933t_ar_ot
tarots66422993t_arots
tarps76527113t_arps_
tarriest83215003tarriest
tars46763953t_ar_s_
tarsi55222173t_ar_si
tarsia65514273t_arsia
tart47566183t_ar__t
tartest72517533t_artest
tartiest82718313t_artiest
tartish101512633t_artish
tarts57242023t_arts_
tastiest83216633tastiest
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
tsades74310993tsades_
tsadi6379913tsadi__
tsar47819803tsar___
tsardom1044483tsardom
tsarinas835273tsarinas
tsaritza1791423tsaritza
tsooris734693tsooris_
tsores65113663tsores_
tsorriss842683tsorriss
tsouris735153tsouris_
tubaist938703tubaist
tubist83013163t_ubist
turista737443t_urista
twist86820983t__wist
typist1139823t_ypist
tzarina1635053tzarina
tzarisms1965213tzarisms
tzars144914273tzar_s_
tzuris15286913tzuris_
uraris63817273uraris_
verist93823893_verist
votarist111012163votarist
waist86132383_wa_ist
wariest105122503_wariest
weariest112914793weariest
wearish132310153wearish
wrist84827563__wrist
yarest95018913_yarest

Search took 7 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 Limit1340272505.97022450.1
3Display Results2502500.0763289.5
 (SQL Overall)1786912506.45227695.4
 
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.