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

116 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
shute8452035(None) 
chute104316461chute
saute55028081saute
scute75520941scute
shote85526101shote
shut76137591shut_
shuted103913171shuted
shutes93518221shutes
shuts85622481shuts
acute74720362acute
astute6310762astute
bhut95425712bhut_
bhuts105812952bhuts
brute75321782brute
bute66739672_bute
chuted124611842chuted
chutes114615772chutes
cute66440452_cute
dhuti937542dhuti
elute54822572elute
flute86823752flute
glute66020902glute
hate78450172_hate
haute89521612haute
hue66642302_hu_e
huge86321652_huge
hut66457292_hut_
huts76737442_huts
hyte109018942_hyte
jute115327892_jute
lute46341012_lute
mute65136872_mute
phut96925972phut_
phuts104613502phuts
route55132072route
salute64418022salute
sate45556102s_ate
sauce75121652sauce
sauted74119602sauted
sautes63924912sautes
scut65835542scut_
scuta75815752scuta
scutes85219192scutes
scuts74522522scuts
sente56432882sente
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shat76456602shat_
shave114425892shave
she66837692sh__e
sheet84836962sheet
shine85533092shine
shire84727132shire
shit76745942shit_
shits84731172shits
shive114423422shive
shoe75933442sh_oe
shone83725982shone
shore85432652shore
shot76150262shot_
shotes95321912shotes
shots84730852shots
shott85332192shott
shout85433172shout_
shouted113911552shouted
shouter103213082shouter
shouts94017722shouts
shove114421042shove
shuck144314532shuck
shul75823152shu_l
shuln84713112shuln
shuls85319712shuls
shun75122772shu_n
shuns85018142shuns
shunt85226512shunt
shunted11339782shunted
shunter103611732shunter
shunts95712022shunts
shush113812542shush
shuteye1343362shuteye
shutter103712142shutter
shuttle1046102shuttle
site47052412s_ite
sixte126216582sixte
skate94721552skate
skite95120052skite
slate55438282slate
slue45332192slu_e
slut45040592slut_
sluts54523982sluts
smite75224872smite
smote75820282smote
smut66629782smut_
smuts75415712smuts
solute64016662solute
souse56530772souse
souter64225922souter
south85223572south
spate74731582spate
spite75430662spite
spue66025522spu_e
spume95817312spume
sputa74612962sputa
state56237332state
stupe75217752stupe
sue35651462s_u_e
suet46754822s_uet
suite54829562suite
supe65932762s_upe
sure45447412s_ure
ute35335882__ute
white114920302white

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.326548131.9
2DLD Change Limit538001161.58034050.6
3Display Results1161160.0303866.7
 (SQL Overall)1786911161.93692299.1
 
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.