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

297 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
thiram113994(None) 
thirams1236801thirams
chiral114614412chiral
chirm125317062chir_m
diram84419472_diram
ihram10310182ih_ram
thairm1156962thair_m
tharm105916642thar_m
therm106018022ther_m
thir76420542thir__
third95912492thir_d
thirds10438602thirds
thirl85416822thir_l
thirls95012062thirls
thirst9312252thirst
thirty12378402thirty
thorax1638252thorax
thraw1110515922th_raw
thrum104713632th_rum
tram67034552t__ram
trigram1077752trigram
ziram163912892_ziram
achiral12109183achiral
ashram1139053ashram
athirst1037873athirst
bharal1138893bharal
cham115532313ch__am
charas114223593charas
charm126124663char_m
chia96026623chi_a_
chiao105618363chi_ao
chias104625513chi_as
chiasm13449103chiasm
chica125818263chica_
chicas135916463chicas
chimar133911463chimar
china105022473china_
chinas115119383chinas
chirk144516183chir_k
chirks155414843chirks
chirms135113983chirms
chiro105320343chir_o
chiros114617773chiros
chirp124717163chir_p
chirps135414003chirps
chirpy16498913chirpy
chirr105015903chir_r
chirre114111853chirre
chirrs114514983chirrs
chiru105317153chir_u
chirus114615693chirus
chital114313883chital
choral115118493choral
chrism13710673chrism
cram85635493__cram
dharma1276103dharma
dirams94413703_dirams
dirham12378273_dirham
dram75832003__dram
engram9310653engram
epigram1247473epigram
ethical1238443ethical
ethogram1446353ethogram
firm96026453_fir_m
foram105124933_foram
gherao1036753gherao
gram77034583__gram
ham86363283_h__am
harem104924453_harem
harm95637793_har_m
herm95636153_her_m
herma105318883_herma
hijab1736803_hijab
hijra1535643_hijra_
hijrah1934273_hijrah
hijras1635773_hijras
hila76228353_hila_
hilar85418143_hilar
hilum105514603_hilum
him86247653_hi__m
hire75538963_hir_e
hired95226263_hired
hiree85427803_hiree
hirer85423123_hirer
hires86134343_hires
hora76136553_hora_
horah117922043_horah
horal86328673_horal
horas86333093_horas
hyrax1838033_hyrax
ihrams1137173ih_rams
imam81718323__imam
joram145816983_joram
khirkah1641423khirkah
lira46928683_lira_
liras56021983_liras
marram10313883marram
mbira977953mbira_
mbiras1077143mbiras
mihrab1335523mihrab
moira71012013moira_
moirai886913moirai
naira5314743naira_
nairas6312773nairas
nizam16310253_nizam
ohia75719363ohi_a_
ohias84415563ohi_as
phial10313203phi_al
pram85733493__pram
ram56867273___ram
rhinal9510183rhinal
scram910621613_scram
sham96436353sh__am
shazam2046603shazam
shibah14387463shibah
shikar1336803shikar
shim95827843shi__m
shire84727133shir_e
shires95225573shires
shirk124817843shir_k
shirks134814123shirks
shirr84716923shir_r
shirrs94413173shirrs
shirt84533893shir_t
shirts94918333shirts
shirty124312553shirty
shiva115915003shiva_
shivah15488533shivah
shivas124512413shivas
shoran94016033shoran
spiral83715343spiral
spirem104214163spirem
tagrag837043tagrag
taiga64115653taiga_
taigas73712553taigas
taipan82410663taipan
tam58663423t___am
tangram1038063tangram
tarama8412723t_arama
team66238653t__eam
terai53525483t_erai
term66233153t_er_m
terra54419653terra_
terrae62915203terrae
terras63516953terras
tetra53417953tetra_
tetrad73612053tetrad
tetras63017613tetras
thae76825563th__ae
thairms1244453thairms
thalami1246053thalami
than76128773th__an
tharms115712243tharms
that75639323th__at
thaw107521313th__aw
theca103311453theca_
thecae11299653thecae
thecal113310303thecal
their85512153their__
theirs94610353their_s
theism1139483theism
them97427043th__em
thenal92712413thenal
thenar9269993thenar
theorem1236263theorem
therapy1536613therapy
there87527393ther_e
thereat104315243thereat
theres96525473theres
theriac1239143theriac
therian10311293therian
thermae125310493thermae
thermal125010963thermal
therme115814993therme
therms115914873therms
theta83414573theta_
thetas93011573thetas
thiamin1236913thi_amin
thick145613353thi_ck
thicks154511993thicks
thief114516293thi_ef
thieve1235963thieve
thigh12410113thi_gh
thighs1346623thighs
thill85918733thi_ll
thills95515383thills
thin76732383thi__n
thine85026853thi_ne
thing96622963thi_ng
things104914283things
think125018793thi_nk
thinks134613353thinks
thinly1238663thinly
thins85826323thi_ns
thio77225413thi__o
thiol87616043thi_ol
thiols95112763thiols
thirdly1444623thirdly
thirlage1243813thirlage
thirled11328093thirled
thirsts1036243thirsts
thirsty1354083thirsty
this76027383thi__s
thoria93012883thoria
thorias102312043thorias
thoric114314033thoric
thorium12208403thorium
thorn85318703thor_n
thorns95314093thorns
thorny12509843thorny
thoro86217873thor_o
thoron94713903thoron
thorp104414263thor_p
thorpe113610093thorpe
thorps113610893thorps
thrall93810293th_rall
thrash12258353th_rash
thrave126010273th_rave
thrawn12769423th_rawn
thraws129211103th_raws
thread105011093thread
threap11569663threap
threat95020463threat
three87526913th_ree
threw1117315713th_rew
thrice114311573thrice
thrift12412043thrift
thrill94910593thrill
thrip103012183th_rip
thrips11299013thrips
thrive125313223thrive
thro77726423th_r_o
throat94819753throat
throb109816853th_rob
throe89321423th_roe
throw118719733th_row
thru76818943th_r_u
thrums11429123th_rums
thuja1535213thuja_
thujas1634433thujas
thurl84912683thur_l
thurls9418713thurls
thuya1135583thuya_
thuyas1234773thuyas
thwart12311683thwart
thyrse1235133thyrse
thyrsi1234453thyrsi
tiara5315903t_iara
tiaras6314533tiaras
tical76021493t_ical
tidal64516443t_idal
tilak91011553t_ilak
tirade7311693t_irade
tire46143353t_ir_e
tired65228903t_ired
tires55437493t_ires
tirl45029923t_ir_l
tirls54519803t_irls
tiro46832363t_ir_o
tiros54524893t_iros
titan53318173t_itan
tora47545993t_ora_
torah87125273t_orah
toras55540373t_oras
trad55630913t__rad
tramp96319773t__ramp
trams75327673t__rams
trap67532803t__rap
tray77632593t__ray
triac74116373tri_ac
triad65217723tri_ad
trial54926353tri_al
tribal8611133tribal
trigrams11116343trigrams
trim65329513t__rim
trinal6516953trinal
trireme935263trireme
twirl85011943twir_l
twirls9478123twirls
twirly12427083twirly
twirp10468943twir_p
twirps11415013twirps
viral86419593_viral
wham125321693wh__am
whidah1634793whidah
whilom1436133whilom
whim126220523whi__m
whipray1843403whipray
whir105519283whir__
whirl114913823whir_l
whirls124710533whirls
whirly15448863whirly
whirr114611193whir_r
whirrs12408593whirrs
whirry15477063whirry
whirs115218093whir_s
zirams17438643_zirams

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 Filter1786911127160.203880251.2
2DLD Change Limit1127162976.26617988.5
3Display Results2972970.1861596.8
 (SQL Overall)1786912976.65526850.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.