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

122 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
bowel10562120(None) 
botel75121861botel
bowed114533421bowed
bowels114315591bowels
bower107328181bower
bowl96827701bow_l
dowel95618191dowel
rowel84721411rowel
towel84920521towel
vowel115515011vowel
babel95821692babel
bagel85116792bagel
bawl95326062baw_l
bedel84219402bedel
bel57148462b__el
betel74419902betel
bevel104517042bevel
bezel165215172bezel
blowed125016692blowed
blower115316572blower
boatel84314092boatel
bode75838752bode_
boded95124962boded
bodes84935102bodes
bogey115220232bogey
bogle85821682bogle
bohea105013732bohea
boil66335182bo_il
bole66448692bole_
boles75448602boles
boll65634752bo_ll
bone65949322bone_
boned85133242boned
boner75133082boner
bones76446532bones
boney105227312boney
booed85127272booed
boral75831702boral
bordel94514572bordel
bore66051332bore_
boreal84817212boreal
bored85034302bored
borer75131272borer
bores76448252bores
botels84815802botels
boule74828042boule
bow87051902bow__
boweled132810692boweled
bowers115523702bowers
bowery146012112bowery
bowled125018142bowled
bowleg12369182bowleg
bowler114217312bowler
bowls106121432bowls
bowmen1399852bowmen
bows96242862bow_s
bowse105420632bowse
bowsed125715972bowsed
bowses115718862bowses
bowyer14368922bowyer
boxed154318612boxed
boxer145016522boxer
boxes145625072boxes
browed125216392browed
cowed115637852cowed
cower104531772cower
cowl97530812cow_l
dowed104632612dowed
dowels104813342dowels
dower95027702dower
embowel14235342embowel
fowl105723632fow_l
hosel86024812hosel
hotel85520752hotel
hovel115017682hovel
howe106734102howe_
howes114730262howes
howl107625692how_l
jewel156711702jewel
jowed164724422jowed
jowl146120302jow_l
koel84519942ko_el
losel54419422losel
lowe75435312lowe_
lowed95233902lowed
lower85830412lower
lowes85732462lowes
model84521692model
mohel104914832mohel
morel75729092morel
motel76623242motel
mowed113629012mowed
mower104523452mower
newel86114132newel
noel45226552no_el
novel85615992novel
owe67041032_owe_
owed86833872_owed
owes75137102_owes
owl66228972_ow_l
power105325952power
rowed94034322rowed
rowels94515452rowels
rowen84921152rowen
rower85430492rower
sorel56231442sorel
sowed94933862sowed
sower85229312sower
towed95134582towed
towels94314642towels
tower85729202tower
trowel94211462trowel
vowed124424572vowed
vowels124410482vowels
vower115220792vower
wowed124023772wowed
yodel94714082yodel
yokel124812612yokel
yowe106728742yowe_
yowed1253025182yowed
yowes114926372yowes
yowl105820952yow_l

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.313570897.8
2DLD Change Limit538001221.68631909.8
3Display Results1221220.0333697.0
 (SQL Overall)1786911222.03287938.5
 
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.