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

126 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
hotel8552075(None) 
botel75121861botel
hosel86024811hosel
hostel93914151hostel
hotels94515511hotels
hovel115017681hovel
motel76623241motel
artel56122742artel
betel74419902betel
boatel84314092boatel
botels84815802botels
bowel105621202bowel
cote66648732cote_
coted85033852coted
cotes76347842cotes
dotal64919622dotal
dote55442882dote_
doted75227072doted
doter65428622doter
dotes65836692dotes
dottel73610892dottel
dowel95618192dowel
hate78450172hate_
hated95734022hated
hater85034752hater
hates86742572hates
hazel176414812hazel
heel75034222h_eel
hoe67562722ho_e_
hoed87837982ho_ed
hoer76533982ho_er
hoes75755732ho_es
hoke115935932hoke_
hoked135326992hoked
hokes126231642hokes
hokey155422182hokey
hole77553392hole_
holed95634132holed
holes84748652holes
holey115626902holey
home98042442home_
homed115425422homed
homely145313172homely
homer105828452homer
homes106938812homes
homey135924842homey
hone77549322hone_
honed95332262honed
honer85332092honer
hones88144492hones
honey115629912honey
hooey114926602hooey
hooted104422662hooted
hooter94123932hooter
hope96639672hope_
hoped115628182hoped
hoper105829142hoper
hopes105835642hopes
horal86328682horal
hose76547242hose_
hosed95830982hosed
hosels94218602hosels
hosen85623882hosen
hoser811529762hoser
hoses85443172hoses
hosey116127022hosey
hosted105020342hosted
hostels103712312hostels
hot67776062hot__
hotbed123310682hotbed
hotch136214732hotch
hotly115815482hotly
hots78349332hot_s
hotted104319942hotted
hotter94720082hotter
housel95217042housel
hove107132222hove_
hovels125413332hovels
hover115524132hover
howe106734102howe_
howes114730262howes
howl107625692ho_wl
hoyle11314412hoyle
hyte109018942hyte_
koel84519942ko_el
losel54419422losel
model84521692model
mohel104914832mohel
morel75729092morel
mote67048082mote_
motels83616892motels
motes75944002motes
motet75641192motet
motey105922952motey
noel45226552no_el
notal55221352notal
note46239962note_
noted65123842noted
noter55025642noter
notes55034582notes
novel85615992novel
ratel54224882ratel
rote46249022rote_
rotes56143902rotes
rotl45029682rot_l
rowel84721412rowel
shote85526102shote_
shotes95321912shotes
shovel124611322shovel
sorel56231442sorel
sotol54917652sotol
tel35647902__tel
total55321822total
tote46643672tote_
toted64929482toted
totem74819372totem
toter55932132toter
totes55139682totes
towel84920522towel
vote74728622vote_
voted93919142voted
voter85121052voter
votes84627082votes
vowel115515012vowel
yodel94714082yodel
yokel124812612yokel

Search took 3 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.390458182.1
2DLD Change Limit538001261.95327547.4
3Display Results1261260.0304200.0
 (SQL Overall)1786911262.37375301.7
 
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.