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

244 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
snottier821738(None) 
knottier12203981knottier
snootier8278381snootier
snoutier8206971snoutier
spottier10207311spottier
blottier10336412blottier
cottier93814172_cottier
dottier83910922_dottier
gnattier934262gnattier
grottier9316672grottier
knotter11317642knott_er
nattier73614622_nattier
nettier74211812_nettier
nittier73512242_nittier
nuttier73112022_nuttier
plottier10327262plottier
pottier93516492_pottier
scattier10267582scattier
scottie937462scottie_
scotties1039752scotties
shittier1137312shittier
slittier837002slittier
slotter73314452slott_er
sluttier836452sluttier
smuttier1035212smuttier
snobbier1234632snobbier
snoopier10177272snoopier
snoozier17185192snoozier
snorter74412662snort_er
snottiest9167972snottiest
snottily1145552snottily
snowier1038792sno_wier
sootier73916612s_ootier
sportier102010052sportier
spotter94514882spott_er
swotter10399472swott_er
another10289153ano_ther
antsier7410773an_tsier
battier93515713_battier
bittier94211663_bittier
blotter94612853blott_er
bottler94211883_bottler
brattier1047663brattier
cattier93317073_cattier
chattier1337513chattier
clothier1335363clothier
cotter84926673_cott_er
cottiers10399153_cottiers
dotier73917033_do_tier
dotter74419343_dott_er
fattier103513463_fattier
floatier1136983floatier
footier104115113_footier
frettier1156593frettier
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
ghostier1235383ghostier
goutier82612353_goutier
grittier9316263grittier
groutier9297173groutier
guttier83911103_guttier
hootier104915353_hootier
hotter94720083_hott_er
hottie92514383_hottie_
hotties103016963_hotties
jettier14358693_jettier
joltier14318493_joltier
jotter134315633_jott_er
knitter11348133knitt_er
knobbier1652703knobbier
knotted12357223knott_ed
knotters12276153knott_ers
knottiest13174563knottiest
knottily1543153knottily
knotting13236573knotting
loftier1037763_loftier
lotter64025603_lott_er
mothier121910213_mothier
motlier92010583_motlier
mottler94410343_mottler
nastier74115293_nastier
natter64420743_natt_er
netter63722023_nett_er
nettler7349503_nettler
nettlier864813_nettlier
niftier10328713_niftier
nobbier11309163_nobbier
noisier759453_noisier
norther1039733_norther
nosier63716323_no_sier
notcher123610933_notcher
noter55025643_no_t_er
nother93815963_no_ther
noticer937273_noticer
notifier1137423_notifier
nutsier7329253_nutsier
nutter63918053_nutt_er
otter54423973__ott_er
pettier94213613_pettier
plotter94113663plott_er
plotties103111413plotties
potter83926983_pott_er
potties93723543_potties
poutier93215323_poutier
prettier1069043prettier
puttier93314503_puttier
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
sloppier1255703sloppier
sloshier1135283sloshier
slotted84613883slott_ed
slotters84012403slott_ers
slotting92612613slotting
smatter93613333smatt_er
smoggier1243973smoggier
smokier1356703smo_kier
smoother13196673smoother
smother123510213smo_ther
snaggier10136303snaggier
snakier112810003sn_akier
snappier1266213snappier
snarkier12336513snarkier
snarlier8278183snarlier
snatcher13167763snatcher
snatchier1455353snatchier
snazzier1642483snazzier
sneakier1245143sneakier
sneerier878103sneerier
sneezier1774333sneezier
sniffier14356643sniffier
snifter10349623snift_er
snippier1255793snippier
snitcher13157373snitcher
snooker113910303sno_oker
snooper93511533sno_oper
snooted84213283snoot_ed
snootiest9178753snootiest
snootily1136253snootily
snooting92813203snooting
snoozer16409193sno_ozer
snorer64316763sno__rer
snorted83813493snort_ed
snorters83410583snort_ers
snorting92613373snorting
snottiness1055593snottiness
snotty9489203snott__y
snouted84311343snout_ed
snoutiest9178253snoutiest
snouting92511923snouting
snoutish1145783snoutish
snubbier1244993snubbier
snuffier14276943snuffier
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
spatter94016523spatt_er
spitter94015183spitt_er
spongier1135733spongier
spookier14175493spookier
spoonier10167653spoonier
sporter93616553sport_er
spotted103713143spott_ed
spotters104313383spott_ers
spottiest11177683spottiest
spottily1335153spottily
spotting112812093spotting
spouter94213223spout_er
sputter94014053sputt_er
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.1561145455.1
2DLD Change Limit1461622447.55019359.2
3Display Results2442440.0932623.7
 (SQL Overall)1786912447.79922912.0
 
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.