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
smote7582027(None) 
emote75421191emote
mote67048081_mote
shote85526081shote
smite75224871smite
smoke115015821smoke
amole75724592amole
azote144416342azote
comte96125472comte
cote66648732_cote
demote94817802demote
dote55442882_dote
emoted94614922emoted
emoter85415192emoter
emotes84620282emotes
gemote94613022gemote
mate65154212_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
sapote8314352sapote
sate45556102s_ate
saute55028082saute
scone74621832scone
scope94821482scope
score75526732score
scot66242602scot_
scoter83815472scoter
scots74025902scots
scute75520942scute
sente56432872sente
shoe75933432sho_e
shone83725972shone
shore85432642shore
shot76150242shot_
shotes95321892shotes
shots84730832shots
shott85332172shott
shove114421032shove
shute84520342shute
site47052412s_ite
sixte126216582sixte
skate94721542skate
skite95120042skite
slate55438282slate
sloe45534952slo_e
slope75823562slope
slot46049822slot_
sloth85019442sloth
slots54830522slots
smaze165012932smaze
smile74823922smile
smit65138412smit_
smiter83616412smiter
smites83921922smites
smith107818052smith
smock135311672smock
smog76317412smo_g
smogs85112162smogs
smoked134311722smoked
smoker124311692smoker
smokes124814342smokes
smokey15398652smokey
smoky14388682smoky
smolt74824162smolt
smolts84411882smolts
smooth11259192smooth
smother123510202smother
smut66629782smut_
smuts75415712smuts
snore55424952snore
snot44745442snot_
snots55225102snots
soke85436262s_oke
sole46053672s_ole
some66040382s_ome
somite84519372somite
sone46649982s_one
soot45761052soot_
sooted73922582sooted
sooth85924052sooth
soothe94214842soothe
soots55536202soots
sooty84924832sooty
sore47059532s_ore
sot310384292s_ot_
soth75932512s_oth
sots45552442s_ots
spate74731582spate
spite75430662spite
spode84617702spode
spoke114818662spoke
spore75428592spore
spot65540682spot_
spots74424102spots
state56237332state
stoae55024262stoae
stoke94922512stoke
stole54928812stole
stone55431182stone
stope74727242stope
store56333812store
stot46347322stot_
stots54828542stots
stott56929782stott
stove85220252stove
suite54829562suite
swore84920812swore
swot75134652swot_
swots85518422swots
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.0961861364.6
2DLD Change Limit538001401.75030742.9
3Display Results1401400.0463043.5
 (SQL Overall)1786911401.89294445.6
 
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.