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

228 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
snoutier820697(None) 
snootier8278371snootier
snottier8217371snottier
goutier82612352_goutier
groutier9297172groutier
knottier12203982knottier
poutier93215322_poutier
scouter93313322scout_er
scouther1356942scouther
shouter103213072shout_er
snobbier1234632snobbier
snoopier10177272snoopier
snoozier17185182snoozier
snorter74412652snort_er
snouted84311342snout_ed
snoutiest9178242snoutiest
snouting92511922snouting
snoutish1145782snoutish
snowier1038782sno_wier
sootier73916602s_ootier
soupier93111752s_oupier
souter64225922s_out_er
souther104116302s_outher
sportier102010052sportier
spottier10207302spottier
spouter94213222spout_er
stouter74012052stout_er
troutier8277142troutier
agouties9337693agouties
another10289153ano_ther
blottier10336413blottier
blousier1055663blousier
bouvier1277433_bouvier
cloudier1135053cloudier
clouter93511683clout_er
cottier93814173_cottier
courier93617873_courier
courtier1059313_courtier
couter84930203_cout_er
couther123914623_couther
couthier13218903_couthier
croupier1246883croupier
dotier73917033_do_tier
dottier83910923_dottier
drouthier1343033drouthier
floatier1136983floatier
flouter104311343flout_er
flutier103011553_flutier
footier104115103_footier
frontier1147313frontier
frostier1148163frostier
frouzier2043703frouzier
ghostier1235383ghostier
gnattier934263gnattier
grottier9316673grottier
grouter84412523grout_er
hootier104915343_hootier
inputter1034203inputter
joltier14318493_joltier
knobbier1652703knobbier
knotter11317643kno_tter
knouted12416763knout_ed
knouting13226793knouting
loftier1037763_loftier
lousier72411623_lousier
mousier93712463_mousier
mouther123812813_mouther
mouthier13208173_mouthier
nastier74115293_nastier
nattier73614623_nattier
nettier74211813_nettier
neuter63713793_neut_er
niftier10328713_niftier
nittier73512243_nittier
nobbier11309163_nobbier
noisier759453_noisier
norther1039733_norther
nosier63716323_no_sier
noter55025643_no_t_er
nother93815963_no_ther
noticer937273_no_ticer
nutsier7329253_n_utsier
nutter63918053_n_utter
nuttier73112023_nuttier
outer55633303__out_er
outlier72216143__outlier
plottier10327263plottier
pottier93516493_pottier
pouter83923983_pout_er
rootier74915393_rootier
roupier9319493_roupier
router65025843_rout_er
saltier74318633s_altier
saluter73512453salut_er
saucier9810283s_aucier
savourier1242973savourier
scantier10309983scantier
scattier10267583scattier
scooter93312863scoot_er
scoter83815473sco_t_er
scottie937443scottie_
scotties1039733scotties
scourer93910433scou_rer
scourger1134723scourger
scouted104112033scout_ed
scouters103411303scout_ers
scouthers1445993scouthers
scouting112612753scouting
scutter93512173s_cutter
shiftier1436333shiftier
shirtier1137933shirtier
shittier1137303shittier
shoalier1137063shoalier
shoddier1334203shoddier
shooter103013973shoot_er
shorter103515493short_er
shortie10411323shortie_
shorties11414573shorties
shoulder1234753shoulder
shouted113911543shout_ed
shouters113510593shout_ers
shouting122711783shouting
showier1339093sho_wier
shutter103712133s_hutter
siltier73413863s_iltier
sirupier1034303sirupier
slatier74016813s_latier
sleetier837883sleetier
slittier837003slittier
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
slotter73314443slo_tter
sloucher13206813sloucher
slouchier1443603slouchier
sloughier1343673sloughier
sluttier836453sluttier
smoggier1243973smoggier
smokier1356703smo_kier
smoother13196663smoother
smother123510203smo_ther
smoulder1133443smoulder
smuttier1035213smuttier
snaggier10136303snaggier
snakier112810003sn_akier
snappier1266213snappier
snarkier12336513snarkier
snarlier8278183snarlier
snazzier1642483snazzier
sneakier1245143sneakier
sneerier878103sneerier
sneezier1774333sneezier
sniffier14356633sniffier
snifter10349623snift_er
snippier1255793snippier
snooker113910303sno_oker
snooper93511533sno_oper
snooted84213273snoot_ed
snootiest9178743snootiest
snootily1136243snootily
snooting92813193snooting
snoozer16409183sno_ozer
snorer64316763sno__rer
snorted83813493snort_ed
snorters83410563snort_ers
snorting92613373snorting
snottiest9167963snottiest
snottily1145543snottily
snout54530633snout___
snouts64915863snout__s
snouty9419953snout__y
snubber11277733sn_ubber
snubbier1244993snubbier
snuffer13318843sn_uffer
snuffier14276933snuffier
snugger9318313sn_ugger
soapier93411713s_oapier
softer94015313s_oft_er
softie93312473s_oftie_
softies103414613s_ofties
soggier93410883s_oggier
soldier82812153s_oldier
sonsier7711743s_onsier
soother104215033s_oother
soppier112711583s_oppier
sorrier72313723s_orrier
sorter64425083s_ort_er
sortie63621983s_ortie_
sortied83314093s_ortied
sorties74126403s_orties
sounder83315383s_ounder
sourer63620213s_ou_rer
souters74422583s_out_ers
southed114313993s_outhed
southern11438913s_outhern
southers114214453s_outhers
splutter10357443splutter
spongier1135733spongier
spookier14175493spookier
spoonier10167653spoonier
sporter93616553sport_er
spotter94514873spo_tter
spouted103412263spout_ed
spouters104011143spout_ers
spouting113511953spouting
sprucier1254793sprucier
spumier1137903s_pumier
sputter94014053s_putter
stockier14217253stockier
stodgier1034223stodgier
stonier72013793sto_nier
stormier1036103stormier
stourie7469343stourie_
stouten7307333stout_en
stoutish1145903stoutish
strutter846493strutter
studier82510053s_tudier
stutter72911463s_tutter
suiter64121813s__uiter
sutler63718393s__utler
sweatier1147033sweatier
swoonier11185133swoonier
swoopier13175143swoopier
swotter10399463swo_tter
syrupier1343053syrupier
touter63821033_tout_er
unrulier845333unrulier
zootier163611173_zootier

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.1731032896.0
2DLD Change Limit1461622288.09318060.3
3Display Results2282280.0932451.6
 (SQL Overall)1786912288.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.