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

208 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
thulia93611(None) 
thulias1035741thulias
abulia83512502abulia
dulia61014982_dulia
hula74923752_hul_a
telia55821142t_elia
thoria93012892thoria
thuja1535212thu_ja
thulium1254472thulium
thuya1135582thu_ya
tulip71111692t_ulip
abelia83114403abelia
aboulia966553aboulia
abulias93210693abulias
abulic106411423abulic
acholia1239973acholia
ahull84010313ahul_l
alula5317093alul_a
amusia839173amusia
anthelia1149113anthelia
anuria6313123anuria
aphelia1249423aphelia
aulic74420243_aulic
bulla74620563_bulla
caulis85320083caulis
challa114014193challa
chela103916803chel_a
chia96026623ch__ia
chili106218483chili_
chiliad1337563chiliad
chilis115517873chilis
chola104718033chol_a
cholla113911023cholla
chufa13489113chu_fa
chukka1433013chukka
chuppa1543973chuppa
cilia73016763_cilia
coulis84018763coulis
culpa93610963_culpa
curia74523773_curia
dahlia1035773dahlia
dhurna1043563dhurna
dhuti937543dhuti_
dhutis1035943dhutis
doula65717773doul_a
dulias71212743_dulias
eluvia936133eluvia
ethylic1546323ethylic
exuvia1644223exuvia
folia83618933_folia
ghoulie1144263ghoulie
glia56423153__glia
halid94424983_halid
halma108219253_halma
halva115414433_halva
heliac111010893_heliac
helio85321193_helio
helix154413013_helix
hila76228353_hil_a
hili75626633_hili_
holla84918493_holla
huic94818053_hu_ic
hulas84920883_hulas
hulk115321613_hul_k
hulks125715483_hulks
hulky155312473_hulky
hull75428783_hul_l
hullo84417453_hullo
hulloa95011183_hulloa
hulls84923563_hulls
humic124113243_humic
humid114213763_humid
huzza1646093_huzza
hyla106716513_hyl_a
ilia46026823__ilia
inulin6311733inulin
khalif1657833khalif
khalifa1742883khalifa
milia72719573_milia
moulin8313283moulin
mulla74317113_mulla
nubia7311233_nubia
obelia8329453obelia
oculi72010793oculi_
ohia75719363oh__ia
pallia83015593pallia
paulin8312983paulin
peculia1147133peculia
phobia13278603phobia
phyla13469183phyl_a
phylic16279553phylic
pula65129373_pul_a
puli65527623_puli_
pulik113613303_pulik
pulis74225603_pulis
pyuria1136953pyuria
qualia1559563qualia
realia6314593realia
rhumba13375553rhumba
scholia1237833scholia
sharia93116733sharia
sheila969843sheila
shelta93111793shelta
shul75823153shul__
shuln84713113shul_n
shuls85319713shul_s
sthenia1058503sthenia
sulfa8313923_sulfa
tabla73318363tabl_a
tabuli839363tabuli_
tabulis938833tabulis
taenia6313193taenia
taffia12286903taffia
tafia84215493t_afia
tala45938053t_al_a
tali46837163t_ali_
tallis63319963tallis
tallit63422733tallit
taluka10426773taluka
tarsia65514273tarsia
tela45532973t_el_a
telial65815363t_elial
telic76019823t_elic
tenia55324483t_enia
tequila1644583tequila
terbia8311153terbia
tesla55612603tesl_a
thaler94613103thaler
thalli958923thalli
thallic1246553thallic
theca103311453th_eca
theelin1038003theelin
thein85919023th_ein
their85512153th_eir
theriac1239143theriac
therian10311293therian
thesis94913733thesis
theta83414573th_eta
thetic11412893thetic
thill85918733thil_l
thills95515383thills
thin76732393th__in
thio77225413th__io
thiolic1247323thiolic
thir76420543th__ir
this76027383th__is
thole85620843thol_e
tholed105113873tholed
tholes94919783tholes
tholing112812333tholing
tholoi9339233tholoi
tholos94213003tholos
thorias102312053thorias
thoric114314043thoric
thrill94910593thrill
thrip103012183th_rip
thud85613913thu__d
thuds95110133thu_ds
thug86415483thu__g
thugs95611993thu_gs
thujas1634433thujas
thuliums1343553thuliums
thumb124511283thu_mb
thumbs13377443thumbs
thump126211573thu_mp
thumps13449353thumps
thunk124911853thu_nk
thunks13459033thunks
thurl84912683thu_rl
thurls9418713thurls
thus76721473thu__s
thusly1235133thusly
thuyas1234773thuyas
thymi13418633thymi_
thymic16307423thymic
tibia7312403t_ibia
tola45236333t_ol_a
toluic837693toluic
toluid738213toluid
torula6610393torul_a
trivia938503trivia
trull54012673trul_l
trulls64110283trulls
truly84111553trul_y
tsuba745563tsu_ba
tsuris62710203tsuris
tuba65422363t_u_ba
tubulin9116433tubulin
tufa75016613t_u_fa
tui37034023t_u_i_
tuis44829643t_u_is
tule45735873t_ul_e
tules54532793t_ules
tulips8137253t_ulips
tulle54019933t_ulle
tumid84114023t_umid
tumuli835933tumuli_
tuna45127843t_u_na
tunic74018223t_unic
tunica8379813t_unica
tupik1149003t_upik
twilit949553twilit
tzuris15286913tzuris
ulna46317333__ulna
ulva75412693__ulva
uvula845153uvul_a
vulva11448803_vulva
yautia937253yautia

Search took 6 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.390458182.1
2DLD Change Limit1127162085.33021147.5
3Display Results2082080.0762736.8
 (SQL Overall)1786912085.79630830.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.