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

135 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
botel7512186(None) 
betel74419901betel
boatel84314091boatel
botels84815801botels
bowel105621201bowel
hotel85520751hotel
motel76623241motel
artel56122742artel
babel95821692babel
bagel85116792bagel
bate66552422bate_
bated85935532bated
bates75846342bates
bedel84219402bedel
bel57148462b__el
betels84515062betels
bethel1169642bethel
bevel104517042bevel
bezel165215172bezel
bite66547012bite_
biter75030032biter
bites75641172bites
boated94221972boated
boatels93510232boatels
boater84622092boater
bode75838762bode_
boded95124962boded
bodes84935102bodes
bogey115220232bogey
bogle85821682bogle
bohea105013732bohea
boil66335182bo_il
boite74426322boite_
boites84322702boites
bole66448692bole_
boles75448602boles
boll65634752bo_ll
bolted94617802bolted
bolter83920752bolter
bone65949322bone_
boned85133242boned
boner75133082boner
bones76446532bones
boney105227312boney
booed85127272booed
booted94822732booted
bootee84323022bootee
boral75831702boral
bordel94514572bordel
bore66051332bore_
boreal84817212boreal
bored85034302bored
borer75131272borer
bores76448252bores
bot59680402bot__
bota66236502bot_a
botas75328782botas
botch126717452botch
botfly1436092botfly
both96533432bot_h
bother115218062bother
bothy136713962bothy
bots66453952bot_s
bott66548572bot_t
bottle84916072bottle
botts75224862botts
boule74828042boule
bowed114533422bowed
bowels114315592bowels
bower107328182bower
bowl96827702bo_wl
boxed154318612boxed
boxer145016522boxer
boxes145625072boxes
brothel12318192brothel
bute66739672bute_
buteo75419892buteo
butes714535872butes
butle75023102butle
butyl1089102butyl
byte96521812byte_
bytes105217492bytes
cote66648732cote_
coted85033852coted
cotes76347842cotes
dotal64919622dotal
dote55442882dote_
doted75227072doted
doter65428622doter
dotes65836692dotes
dottel73610892dottel
dowel95618192dowel
hosel86024822hosel
hostel93914152hostel
hotels94515522hotels
hovel115017682hovel
koel84519952ko_el
losel54419422losel
model84521692model
mohel104914832mohel
morel75729092morel
mote67048082mote_
motels83616902motels
motes75944002motes
motet75641192motet
motey105922952motey
noel45226552no_el
notal55221352notal
note46239962note_
noted65123842noted
noter55025642noter
notes55034582notes
novel85615992novel
ratel54224882ratel
rote46249022rote_
rotes56143902rotes
rotl45029682rot_l
rowel84721412rowel
sorel56231442sorel
sotol54917652sotol
tel35647902__tel
total55321822total
tote46643672tote_
toted64929482toted
totem74819372totem
toter55932132toter
totes55139682totes
towel84920522towel
vote74728622vote_
voted93919142voted
voter85121052voter
votes84627082votes
vowel115515012vowel
yodel94714082yodel
yokel124812612yokel

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.296603685.8
2DLD Change Limit538001351.61033416.1
3Display Results1351350.0334090.9
 (SQL Overall)1786911351.93992156.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.