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

159 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
eustele73819(None) 
eusteles838041eusteles
austere7312992austere
bustle84015482bust_le
hustle93113992hust_le
justle133211582just_le
mustee83922102muste_e
pustule937682pustule
rustle63615412rust_le
stele55026842__stele
austerer838383austerer
bastile9313913bastile
bushel114513943bushel_
busheled1465273busheled
busheler1374763busheler
bushels124110713bushels
busted95123153buste_d
buster84726493buste_r
busters94724133busters
bustled104011523bustled
bustler94012573bustler
bustles93816323bustles
butene8312623bu_tene
butle75023103bu_t_le
castle84918963cast_le
cuittle946403cuittle
cutely115312803cu_tely
cuttle84113893cu_ttle
ductile1048483ductile
ductule1065503ductule
dusted83918373duste_d
duster74919723duste_r
dusters84918363dusters
dustily113211533dustily
easel54521113eas_el_
easeled8159863eas_eled
easels65914553eas_els
easter65027983easte_r
easterly11246643easterly
eastern74412533eastern
easters75125683easters
ekpwele1641963ekpwele
ekuele1034383e_kuele
ensile62616473ens_ile
epistle957893epist_le
epistyle1364073epistyle
estate64719763e_state
esteem838813e_steem
ester54727713e_ste_r
esters64627733e_sters
esthete1047433e_sthete
eustacy1254663eustacy
eustasy1043873eustasy
frustule1154483frustule
fusee86224583fus_e_e
fusel85218493fus_el_
fusels94412453fus_els
fusible1237023fusible
fusile94313493fus_ile
fustily133111383fustily
futile93914953fu_tile
gustable11138203gustable
gusted84316723guste_d
gustily113010903gustily
guttle74111973gu_ttle
hostel93914153hostel_
hosteled1237293hosteled
hosteler1137283hosteler
hostels103712323hostels
hostile10312553hostile
hurtle93512943hurt_le
hustled113210133hustled
hustler103410753hustler
hustles103414173hustles
istle52214713_ist_le
jostle13319863jost_le
justed144215773juste_d
juster134617013juste_r
justers143815733justers
justest1449893justest
justice1637423justice
justled15338093justled
justles143311433justles
justly16307253just_ly
kantele1138253kantele
listee64223063liste_e
listel64214743listel_
listels74212433listels
lusted74319443luste_d
luster64023673luste_r
lustered92510613lustered
lusters73921443lusters
lustily103611243lustily
lustre64011683lust_re
mestee84523883meste_e
muscle10310973mus_cle
musette938433musette
mussel83412903mussel_
mussels9419843mussels
musted93321073muste_d
mustees94614923mustees
mustelid1144883mustelid
musteline1146973musteline
muster84724523muste_r
mustered112511513mustered
musters94522513musters
mustily123613633mustily
mutely113811653mu_tely
mutule8311423mu_tule
nestle63013953nest_le
ousel55222403ous_el_
ousels64815283ous_els
ousted73720583ouste_d
ouster64223733ouste_r
ousters74122793ousters
outsee63121803outse_e
outsell7109263outsell
outsole71013433outsole
outtell797883outtell
pastel85918713pastel_
pastels95215183pastels
pestle83215843pest_le
pistole92414313pistole
pustuled1134953pustuled
pustules1038443pustules
puttee85919723putte_e
restyle1038763restyle
reusable10811273reusable
rushee93818773rushe_e
rustable101511363rustable
rusted75020923ruste_d
rustily103112993rustily
rustled83311323rustled
rustler73512343rustler
rustles73416413rustles
rutile65217683ru_tile
stale55637103__stale
steel55721993__steel
stela54019043__stela
stelae63716483__stelae
steles63725663__steles
stere55328543__stere
stile54931573__stile
stole54928813__stole
style85519363__style
subtile91912623subtile
subtle82113433subt_le
suttee63721543sutte_e
systole1035763systole
tele45040873___tele
testee64323303teste_e
trustee73514443truste_e
turtle63213573turt_le
tussle637143tus_sle
tutee5423523tu_te_e
unsteel738793unsteel
usable84012553_usable
utile54718933_u_tile
vestee94319153veste_e

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.393454684.5
2DLD Change Limit1340271596.14021828.5
3Display Results1591590.0632523.8
 (SQL Overall)1786911596.59627090.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.