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

289 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
spottier1020731(None) 
pottier93516491_pottier
snottier8217381snottier
sportier102010051sportier
spotter94514881spott_er
blottier10336412blottier
cottier93814172_cottier
dottier83910922_dottier
grottier9316672grottier
knottier12203982knottier
pettier94213612_pettier
plottier10327262plottier
potter83926982_pott_er
potties93723542_potties
poutier93215322_poutier
puttier93314502_puttier
scattier10267582scattier
scottie937462scottie_
scotties1039752scotties
shittier1137312shittier
slittier837002slittier
slotter73314452slott_er
sluttier836452sluttier
smuttier1035212smuttier
snootier8278382snootier
snoutier8206972snoutier
sootier73916612s_ootier
spatter94016522spatt_er
spitter94015182spitt_er
spongier1135742spongier
spookier14175492spookier
spoonier10167652spoonier
sporter93616552sport_er
spotted103713142spott_ed
spotters104313382spott_ers
spottiest11177692spottiest
spottily1335152spottily
spotting112812092spotting
spouter94213222spout_er
sputter94014052sputt_er
swotter10399472swott_er
battier93515723_battier
bittier94211663_bittier
blotter94612853blott_er
bottler94211883_bottler
brattier1047663brattier
cattier93317073_cattier
chattier1337513chattier
clothier1335363clothier
cotter84926673_cott_er
cottiers10399163_cottiers
dotier73917033_do_tier
dotter74419343_dott_er
fattier103513463_fattier
floatier1136983floatier
footier104115113_footier
frettier1156593frettier
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
ghostier1235383ghostier
gnattier934263gnattier
goutier82612353_goutier
grittier9316263grittier
groutier9297173groutier
guttier83911103_guttier
hootier104915353_hootier
hotter94720083_hott_er
hottie92514383_hottie_
hotties103016963_hotties
jettier14358693_jettier
joltier14318493_joltier
jotter134315633_jott_er
knotter11317643knott_er
loftier1037763_loftier
lotter64025603_lott_er
mothier121910213_mothier
motlier92010583_motlier
mottler94410343_mottler
nattier73614623_nattier
nettier74211813_nettier
nittier73512243_nittier
nuttier73112023_nuttier
otter54423973__ott_er
partier93520713_partier
pastier94320383_pastier
patter84628263_patt_er
pattie84020963_pattie_
patties93425143_patties
peatier94017233_peatier
pestier94317403_pestier
petter83924773_pett_er
pithier123010293_pithier
pitier84019823_p_itier
platier93716293_platier
plotter94113663plott_er
plotties103111413plotties
pockier153911603_pockier
podgier11338723_podgier
poetiser1037313_poetiser
poetizer1936813_poetizer
pointier1038303_pointier
pokier124914633_po_kier
politer92417073_politer
porkier133712343_porkier
pornier93413133_pornier
porter84224413_port_er
portiere1038773_portiere
portlier1038373_portlier
poster84129173_post_er
postie84123963_postie_
posties93128813_posties
pother113818853_po_ther
potpie103412433_potpie_
potpies113116173_potpies
potsie83916033_potsie_
potsies93019483_potsies
potted94624013_pott_ed
potteen9319673_potteen
potterer102310263_potterer
potters94024343_pott_ers
pottery123011073_pott_ery
pottiest102815973_pottiest
potting103720893_potting
pottle84416103_pottle_
pottles93816983_pottles
potzer174411213_po_tzer
pouter83923983_pout_er
powter114116033_powt_er
poxier153812113_po_xier
prettier1069043prettier
purtier93214093_purtier
putter83921443_putt_er
puttie84116303_puttie_
puttied103811163_puttied
puttiers10288013_puttiers
putties94420023_putties
rattier74015593_rattier
rootier74915393_rootier
rotter64325463_rott_er
ruttier73412283_ruttier
saltier74318633s_altier
scantier10309983scantier
scatter93815173scatt_er
scooter93312873scoot_er
scoter83815483sco_t_er
scouter93313323scout_er
scouther1356943scouther
scutter93512173scutt_er
setter64023723s_ett_er
settler73410653s_ettler
shatter103615703shatt_er
shiftier1436343shiftier
shirtier1137943shirtier
shoalier1137073shoalier
shoddier1334213shoddier
shooter103013993shoot_er
shorter103515503short_er
shortie10411343shortie_
shorties11414583shorties
shotted113912403shott_ed
shotten10288463shott_en
shotting123012383shotting
shouter103213083shout_er
showier1339103sho_wier
shutter103712143shutt_er
shuttler1164903shuttler
siltier73413863s_iltier
sitter63323383s_itt_er
skitter113810403skitt_er
slatier74016813s_latier
sleetier837883sleetier
slitter73615873slitt_er
slobbier1254633slobbier
sloppier1255713sloppier
sloshier1135283sloshier
slotted84613883slott_ed
slotters84012403slott_ers
slotting92612613slotting
smatter93613333smatt_er
smoggier1243973smoggier
smokier1356703smo_kier
smoother13196673smoother
smother123510213smo_ther
snobbier1234633snobbier
snoopier10177273snoopier
snoozier17185193snoozier
snorter74412663snort_er
snottiest9167973snottiest
snottily1145553snottily
snowier1038793sno_wier
soapier93411713s_oapier
softer94015313s_oft_er
softie93312483s_oftie_
softies103414613s_ofties
soggier93410883s_oggier
soldier82812153s_oldier
sonsier7711743s_onsier
soother104215043s_oother
soppier112711583s_oppier
sorrier72313733s_orrier
sorter64425093s_ort_er
sortie63621993s_ortie_
sortied83314103s_ortied
sorties74126403s_orties
sotted74121403s_ott_ed
sottish10129443s_ottish
soupier93111753s_oupier
souter64225923s_out_er
souther104116303s_outher
spacier114011633sp_acier
sparkier14298033sparkier
sparrier10329143sparrier
spatted104014143spatt_ed
spatters103914703spatt_ers
spatting113111763spatting
specter113111733spect_er
speedier1146623speedier
spelter94113703spelt_er
spendier1147143spendier
spherier1337783spherier
spicier115112463sp_icier
spier75728033sp___ier
spiffier16255883spiffier
spikier13369983sp_ikier
spinier93715163sp_inier
spirier93214073sp_irier
spitfire1343053spitfire
spitted103912703spitt_ed
spitters104113383spitt_ers
spitting113012323spitting
spittle937923spittle_
spittles1038333spittles
splatter10348883splatter
splitter10348443splitter
splotchier1741933splotchier
splutter10357443splutter
spoiler93310683spo_iler
sponger1038523spo_nger
spoofer12368723spo_ofer
spooler93711383spo_oler
spoonies101911753spoonies
sported104015433sport_ed
sporters103714063sport_ers
sportiest111711033sportiest
sportif1238803sporti_f
sportily1337733sportily
sporting112415463sporting
sportive1348333sportive
spotlit947303spotli_t
spottiness1285763spottiness
spotty11448583spott__y
spouted103412263spout_ed
spouters104011163spout_ers
spouting113511953spouting
sprier84119063sp__rier
spritzer1944563spritzer
sprucier1254793sprucier
spumier1137903sp_umier
spunkier14235823spunkier
spurrier10297693spurrier
spurter94013003spurt_er
sputterer11165263sputterer
sputters104012873sputt_ers
sputtery13366473sputt_ery
squattier1843713squattier
stockier14217253stockier
stodgier1034223stodgier
stonier72013793sto_nier
stormier1036103stormier
stotted83511423stott_ed
stotting92811163stotting
stouter74012053stout_er
stutter72911463stutt_er
sultrier837773sultrier
swatter104113323swatt_er
sweatier1147033sweatier
swoonier11185133swoonier
swoopier13175143swoopier
swotted11398713swott_ed
swotters11448483swott_ers
swotting12268483swotting
tattier74216243_tattier
toothier1136423toothier
totter65021463_tott_er
trotter73312253trott_er
troutier8277153troutier
wittier103910823_wittier
zootier163611173_zootier

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 Limit1461622897.37319824.0
3Display Results2892890.1102627.3
 (SQL Overall)1786912897.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.