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

234 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
thairms124445(None) 
thairm1156961thairm_
tharms115712241tha_rms
chairs114916182chair_s
charms135218842cha_rms
chirms135113982ch_irms
hairs86225172_hair_s
harms106829012_ha_rms
shairds11216262shairds
shairns10276782shairns
tharm105916642tha_rm_
theirs94610352their_s
theisms1237762theisms
therms115914872th_erms
thirams1236822th_irams
thirds10438602th_irds
thirls95012062th_irls
affirms1534383affirms
aims67738183__ai_ms
airns55521033__airns
airs46447423__air_s
airts55626343__airts
alarms85913053ala_rms
arms66137493__a_rms
atheisms1346923atheisms
bairns86710873_bairns
barms96128463_ba_rms
cairds96411513_cairds
cairns85313303_cairns
chaines124518733chaines
chains114819703chai_ns
chair105519633chair__
chaired134211243chaired
chairman15106383chairman
chairmans1685143chairmans
chairmen15105473chairmen
chais107530313chai__s
chaises124317493chaises
chakras16428503chakras
chams126028503cha__ms
charas114223613cha_ras
chards125119733cha_rds
chares115631803cha_res
charism14712203charism
charisms15710263charisms
charks155219703cha_rks
charm126124663cha_rm_
charros124312143charros
charrs115219193cha_rrs
chars105936643cha_r_s
charts115823093cha_rts
chasms135513143cha_sms
chiasms14357523chiasms
chirks155414843ch_irks
chirm125317063ch_irm_
chiros114617773ch_iros
chirps135414003ch_irps
chirrs114514983ch_irrs
chirus114615693ch_irus
choirs114911883choir_s
chrisms1499143chrisms
claims105211573clai_ms
deairs74013783deair_s
dharma1276103dha_rma
dharmas1356513dha_rmas
fairs85825443_fair_s
farms106324953_fa_rms
firms105217423__firms
flairs95711913flair_s
gharris11306433gharris
glaires84010143glaires
glairs75211333glair_s
haars85620473_haar_s
haems105517013_ha_ems
haeres94017033_haeres
haiks125120933_hai_ks
haikus13538293_haikus
hails85231643_hai_ls
haints94417583_haints
hair76330143_hair__
hairdo1036433_hairdo
hairdos1136823_hairdos
haired105117173_haired
hairy115316833_hair_y
hakims1537303_hakims
halms105225213_ha_lms
hams96446133_ha__ms
hards96435653_ha_rds
harems115513823_harems
hares86255543_ha_res
harks126333433_ha_rks
harls85634503_ha_rls
harm95637793_ha_rm_
harps105926873_ha_rps
harts88441593_ha_rts
haulms11558503_haulms
heirs85618563_heir_s
herms105626433_h_erms
hims95230973_h_i_ms
hires86134343_h_ires
inarms8410093ina_rms
infirms1245563infirms
lairds74711613_lairds
lairs55425873_lair_s
maims96321793_mai_ms
mairs76228303_mair_s
mohairs1234953mohair_s
nairas6312783_nairas
nairus639143_nairus
pairs75325833_pair_s
pharos11312063pha_ros
rearms85114653rea_rms
shaird10288703shair_d
shairn9269063shair_n
shaloms1288983shaloms
shams105829413sha__ms
shards104319173sha_rds
shares95236413sha_res
sharias102516003sharias
sharifs13279903sharifs
sharks135019723sha_rks
sharns95516983sha_rns
sharps115516083sha_rps
shawms14579563sha_wms
shims104422553sh_i_ms
shires95225573sh_ires
shirks134814123sh_irks
shirrs94413173sh_irrs
shirts94918343sh_irts
smarms105712533sma_rms
squirms18376343squirms
stairs65416333stair_s
swarms116112173swa_rms
tahinis1048013tahinis
tahrs85412333t_ahr_s
taigas73712563t_aigas
tails55634193t_ai_ls
tains54936323t_ai_ns
taints64520533t_aints
tams67247933t_a__ms
tapirs84113173tapir_s
tares57456563t_a_res
tarns56433953t_a_rns
taros55640823t_a_ros
tarps76527113t_a_rps
tarres64723043t_arres
tars46763953t_a_r_s
tarts57242023t_a_rts
teams75726513tea__ms
tears55436463tea_r_s
tediums10266973tediums
terms75523473t__erms
thacks154311923tha_cks
thalami1246083thalami
thalamus1343603thalamus
thalers106212263thalers
thalliums1443253thalliums
thallus1035603thallus
thanes94918983tha_nes
thanks134313133tha_nks
thawers13428483thawers
thaws116515463tha__ws
theatres11298633theatres
theines104013233theines
theins95015423thei_ns
their85512153their__
theism1139483theism_
theists1039153theists
theorems1344693theorems
theres96525473th_eres
therm106018023th_erm_
therme115814993th_erme
thermes126214613th_ermes
thermos124610753th_ermos
thicks154511993th_icks
thighs1346633th_ighs
thills95515383th_ills
things104914303th_ings
thinks134613363th_inks
thins85826333th_i_ns
thiols95112763th_iols
thir76420543th_ir__
thiram1139963th_iram
third95912493th_ir_d
thirl85416823th_ir_l
thirst9312253th_irst
thirsts1036243th_irsts
thirty12378403th_irty
this76027383th_i__s
thorias102312053thorias
thoriums13166403thoriums
thorns95314103th_orns
thorps113610893th_orps
thrifts1335523thrifts
thrills10398783thrills
thrips11299013thri_ps
thrives134611713thrives
thrums11429123th_rums
thuliums1343553thuliums
thurls9418713th_urls
thwarts1345023thwarts
tiaras6314553tia_ras
tires55437493t__ires
tirls54519803t__irls
tiros54524893t__iros
traiks104013713trai_ks
trails64622513trai_ls
trains64725343trai_ns
traits65121983trai_ts
trams75327673tra__ms
trims75021473t_ri_ms
truisms9106823truisms
tsarism958253tsarism
tsarisms1056653tsarisms
tsars56717113tsa_r_s
twains95811183twai_ns
twirls9478123t_wirls
twirps11415013t_wirps
tzarism1866323tzarism
tzarisms1965213tzarisms
tzars144914273tza_r_s
unarms839243una_rms
unhairs1036373unhair_s
vairs85019133_vair_s
wairs86424063_wair_s
warms107726853_wa_rms
whams135515643wha__ms
wharfs1546373wha_rfs
whims134515333wh_i_ms
whirls124710533wh_irls
whirrs12408593wh_irrs
whirs115218093wh_ir_s
yairds10448023_yairds
zaires1539703_zaires

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 Limit1340272347.09318895.7
3Display Results2342340.0802925.0
 (SQL Overall)1786912347.57923577.1
 
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.