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 “smote” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 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
smote7582028(None) 
emote75421191emote
mote67048081_mote
shote85526101shote
smite75224871smite
smoke115015821smoke
amole75724592amole
azote144416342azote
comte96125472comte
cote66648732_cote
demote94817802demote
dote55442882_dote
emoted94614922emoted
emoter85415192emoter
emotes84620282emotes
gemote94613022gemote
mate65154222_mate
mete64438132_mete
mite66249412_mite
mode75840302_mode
moke106234222_moke
mole66251832_mole
mome85239352_mome
monte75829772_monte
mope86838042_mope
more67154522_more
moste75925082_moste
mot57279422_mot_
motel76623242_motel
motes75944002_motes
motet75641192_motet
motey105922952_motey
moth96731332_moth
mots66853162_mots
mott66648442_mott
motte75526972_motte
moue65835572_moue
move96630722_move
mute65136872_mute
note46239962_note
osmole8128512osmole
osmose8108002osmose
quote143714772quote
remote84222602remote
rote46249022_rote
samite83020602samite
sapote8314362sapote
sate45556102s_ate
saute55028082saute
scone74621832scone
scope94821482scope
score75526742score
scot66242612scot_
scoter83815482scoter
scots74025912scots
scute75520942scute
sente56432882sente
shoe75933442sho_e
shone83725982shone
shore85432652shore
shot76150262shot_
shotes95321912shotes
shots84730852shots
shott85332192shott
shove114421042shove
shute84520352shute
site47052412s_ite
sixte126216582sixte
skate94721552skate
skite95120052skite
slate55438282slate
sloe45534952slo_e
slope75823562slope
slot46049832slot_
sloth85019452sloth
slots54830532slots
smaze165012932smaze
smile74823922smile
smit65138412smit_
smiter83616412smiter
smites83921922smites
smith107818052smith
smock135311672smock
smog76317412smo_g
smogs85112162smogs
smoked134311722smoked
smoker124311692smoker
smokes124814342smokes
smokey15398652smokey
smoky14388682smoky
smolt74824162smolt
smolts84411882smolts
smooth11259202smooth
smother123510212smother
smut66629782smut_
smuts75415712smuts
snore55424952snore
snot44745452snot_
snots55225122snots
soke85436262s_oke
sole46053672s_ole
some66040382s_ome
somite84519372somite
sone46649982s_one
soot45761062soot_
sooted73922592sooted
sooth85924062sooth
soothe94214852soothe
soots55536212soots
sooty84924842sooty
sore47059532s_ore
sot310384302s_ot_
soth75932522s_oth
sots45552452s_ots
spate74731582spate
spite75430662spite
spode84617702spode
spoke114818662spoke
spore75428592spore
spot65540692spot_
spots74424112spots
state56237332state
stoae55024262stoae
stoke94922512stoke
stole54928812stole
stone55431182stone
stope74727242stope
store56333812store
stot46347332stot_
stots54828552stots
stott56929792stott
stove85220252stove
suite54829562suite
swore84920822swore
swot75134662swot_
swots85518432swots
tote46643672_tote
vote74728622_vote
wrote84717482wrote
zlote143912942zlote

Search took 2 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 Filter178691538000.300595636.7
2DLD Change Limit538001401.54634799.5
3Display Results1401400.0463043.5
 (SQL Overall)1786911401.89294445.6
 
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.