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

188 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
pustules103844(None) 
pustule937681pustule_
pustuled1134951pustuled
bustles93816322bust_les
ductules1155542ductules
eusteles838042eusteles
frustules1244662frustules
hustles103414172hust_les
justles143311432just_les
mutules9311842mu_tules
opuscules1342752opuscules
pastures10311962pastures
pestles93217692pest_les
pistoles102514722pistoles
postures10313782postures
pustular1045152pustular
pustulates1276212pustulates
pustulous1143432pustulous
rustles73416412rust_les
apostles1037753apost_les
australes9317763australes
bascules1236683bascules
bastiles10313353bastiles
bustle84015483bust_le_
bustled104011523bust_led
bustler94012573bust_ler
bustlers104210623bust_lers
butles84423913bu_t_les
castles94917733cast_les
cestuses1038083cestuses
cistuses1038283cistuses
costumes1258013costumes
cuittles1045903cuittles
cultures10310153cultures
cultuses1037753cultuses
cupules113210263cu_pules
cuscuses1235863cuscuses
custodes1136653custodes
cuttles93613923cu_ttles
ductule1065503ductule_
dustless9328353dust_less
dustups1033913dustu_ps
epistles1047783epist_les
epistyles1454143epistyles
eustele738193eustele_
fistulas1155403fistulas
frustule1154483frustule_
futures10310263fu_tures
gestures9310013gestures
guayules1243223guayules
gustables12165223gustables
gustless9287683gust_less
gustoes879873gust_oes
guttles83011933gu_ttles
hostiles11312213hostiles
hurtles103913753hurt_les
hustle93113993hust_le_
hustled113210133hust_led
hustler103410753hust_ler
hustlers11349203hust_lers
istles62814983_ist_les
jostles143411143jost_les
justices1737523justices
justle133211583just_le_
justled15338093just_led
lunules738953lu_nules
lustres73013233lust_res
lususes736713lus_uses
misrules1039383misrules
mistunes10311133mistunes
multures1039333multures
muscles11310563mus_cles
mustees94614923must_ees
mutuels935943mu_tuels
mutule8311423mu_tule_
nestles73015463nest_les
noctules1036583noctules
nurtures837443nurtures
opuscule1242823opuscule_
oscules938123_oscules
outsoles8813113outsoles
outsulks1244993outsulks
pantiles103617153pantiles
papules112411573p_apules
passuses1036773passuses
pastels95215183pastel_s
pastes85233913past__es
pasties94529813past_ies
pastilles1148703pastilles
pastils94416173pastil_s
pastimes123611903pastimes
pastises103616053pastises
pastless102411203past_less
pastries101517423pastries
pasture9311463pasture_
pastured1138233pastured
pasturer1037523pasturer
pasturers1136393pasturers
pestholes1448233pestholes
pestle83215843pest_le_
pestled102711453pest_led
pettles93916483p_ettles
pictures1249343pictures
pilules9510623p_ilules
pinnules1036463pinnules
pintles94118723pint_les
pistes85325633pist__es
pistils93314303pistil_s
pistole92414313pistole_
pistoled11259593pistoled
pistols93213983pistol_s
plumules1234663plumules
posoles9314883pos_oles
postages112815323postages
postals93716373postal_s
postholes14410453postholes
posties93128813post_ies
postludes1244623postludes
postulates1268963postulates
posture9313253posture_
postured1139493postured
posturer1038923posturer
posturers1137053posturers
pottles93816983p_ottles
prattles10189403prattles
prostyles14157113prostyles
protyles13249833protyles
puddles113613823pu_ddles
pules74538813p___ules
pulques1835323pulqu_es
punctures1345343punctures
pungles104013713pu_ngles
punties94520783punt_ies
purfles122511843pu_rfles
purples112712833pu_rples
purpures1276143purpures
pursues94111373pursu_es
puses75532203pus___es
pushes114621663pus__hes
pushups1433653pushu_ps
pusley11379613pus__ley
pusleys12286233pus__leys
pusses84322843pus__ses
pussies93615693pus_sies
pussley12375123pus_sley
pussleys13273173pus_sleys
pusslies1036173pusslies
pustulant1145023pustulant
pustulants1253423pustulants
pustulate1177243pustulate
pustulated1375543pustulated
putsches1535313putsches
puttees93612913pu_ttees
putties94420023pu_tties
puttyless1442013puttyless
putzes174212523pu_t_zes
puzzles17318973pu_zzles
restyles1139193restyles
ruptures1056683ruptures
rustle63615413rust_le_
rustled83311323rust_led
rustler73512343rust_ler
rustlers8339853rust_lers
rustless83510243rust_less
rutiles74315843ru_tiles
spurtles1037783spurt_les
stales65538293__stales
steles63725663__steles
stiles64328773__stiles
stoles63927673__stoles
stulls63912983__stulls
stupes84116953__stupes
styles94418653__styles
subrules1039723subrules
sutures7314223su_tures
systoles1146483systoles
tubules9310233tu_bules
tules54532793___tules
turtles72914343turt_les
tussles737833tus_sles
untunes72211253_untunes
upscales12155993upscales
upstages11147373upstages
upstares10178583upstares
upstates10189643upstates
usques15126803_usqu_es
vestures11311043vestures
vultures1137213vultures

Search took 9 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.420425454.8
2DLD Change Limit1461621887.56319325.9
3Display Results1881880.0802350.0
 (SQL Overall)1786911888.06322161.9
 
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.