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

129 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
pustuled113495(None) 
pustule937681pustule_
pustules1038441pustules
bustled104011522bust_led
hustled113210132hust_led
justled15338092just_led
pastured1138232pastured
pestled102711452pest_led
pistoled11259592pistoled
postured1139492postured
pustular1045152pustular
pustulated1375542pustulated
rustled83311322rust_led
busheled1465273busheled
busted95123153bust__ed
bustle84015483bust_le_
bustler94012573bust_ler
bustles93816323bust_les
butled94818603bu_t_led
castled104311513cast_led
costumed1365033costumed
cuittled1133993cuittled
cultured1137233cultured
cuttled10319933cu_ttled
ductule1065503ductule_
ductules1155543ductules
dusted83918373dust__ed
ensouled935833ensouled
eustele738193eustele_
eusteles838043eusteles
frustule1154483frustule_
frustules1244663frustules
gestured1036993gestured
gusted84316723gust__ed
guttled9378993gu_ttled
hosteled1237293hosteled
hurtled11339593hurt_led
hustle93113993hust_le_
hustler103410753hust_ler
hustles103414173hust_les
insouled936113insouled
jostled15267083jost_led
justed144215773just__ed
justle133211583just_le_
justles143311433just_les
lusted74319443lust__ed
lustered92510603lustered
lustred8359053lust_red
misruled1137083misruled
mistuned1157723mistuned
muscled1237783mus_cled
musted93321073must__ed
mustelid1144883mustelid
mustered112511503mustered
mutule8311423mu_tule_
mutules9311843mu_tules
nestled8349913nest_led
nurtured935253nurtured
opuscule1242823opuscule_
opuscules1342753opuscules
ousted73720583oust__ed
outled74020343ou_t_led
outsulked14124753outsulked
pantiled113111593pantiled
pasted94426903past__ed
pastored1139973pastored
pasture9311463pasture_
pasturer1037523pasturer
pastures10311963pastures
pestered112814973pestered
pestle83215843pest_le_
pestles93217693pest_les
petaled103614153p_etaled
pettled103611513p_ettled
pictured1346573pictured
pistole92414313pistole_
pistoles102514723pistoles
pistolled1255173pistolled
portaled11239203portaled
posted93722493post__ed
postlude1144543postlude
postulated1377653postulated
posture9313253posture_
posturer1038923posturer
postures10313783postures
prattled11246533prattled
puddled123011193pu_ddled
puled84926523p___uled
pulled94322193pu__lled
pummeled1543373pummeled
punctured1444183punctured
pungled114210083pu_ngled
punted94618713punt__ed
purfled13248733pu_rfled
purled94520753pu__rled
purpled12299783pu_rpled
pursued10388133pursu_ed
pushed125017463pus__hed
pusley11379613pus__ley
pussley12375123pus_sley
pustulant1145023pustulant
pustulate1177243pustulate
pustulates1276213pustulates
pustulous1143433pustulous
putted94220253pu_t_ted
puttered112611143puttered
puttied103811163pu_ttied
putzed18409113pu_t_zed
puzzled18286653pu_zzled
restyled1236953restyled
ruptured1144683ruptured
rusted75020923rust__ed
rustle63615413rust_le_
rustler73512343rust_ler
rustles73416413rust_les
souled75419823__souled
staled74728103__staled
stoled74521593__stoled
styled105613103__styled
sutured8310373su_tured
turtled8309683turt_led
tussled835413tus_sled
tutued7349413tu_tu_ed
unruled8311373_unruled
untuned82010823_untuned
upscaled13144873upscaled
upstaged12135243upstaged
upstared11156573upstared
vestured1237463vestured

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621297.42319690.4
3Display Results1291290.0602150.0
 (SQL Overall)1786911297.88922650.7
 
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.