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 “dewing” 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
dewing11411570(None) 
dawing114819821dawing
deking125614551deking
dowing114221511dowing
hewing134514241hewing
jewing174411421jewing
mewing123914201mewing
sewing103819621sewing
tewing103914821tewing
aweing103911252aweing
awing96827322_awing
bedewing1537142bedewing
being84920502be_ing
bewig1138902bewi_g
bowing124723062bowing
brewing133411152brewing
cawing124322612cawing
ceding104014802ceding
cering94522532cering
chewing163911142chewing
clewing13359582clewing
cowing124526322cowing
crewing133212632crewing
daring84928682daring
dating85326482dating
dawning124111012dawning
dawting123610672dawting
dazing175516512dazing
dealing94323232dealing
deaning94020472deaning
deaving123814752deaving
decking153915592decking
deeding103315122deeding
deeming113913122deeming
defang1137752defang
define104718142define
defying15328822defying
deicing11312192deicing
deign74312802de_ign
dekeing13358352dekeing
deleing93313952deleing
delving123711572delving
demoing11311752demoing
denning93515172denning
denting94422182denting
denying123711292denying
design8408932design
deucing1139392deucing
dewan95718042dewan_
dewans105215142dewans
dewaxing20215292dewaxing
dewier104013462dewier
dewily1338342dewily
dezinc1836052dezinc
dicing105718762dicing
dieing84018652dieing
dieting93616832dieting
diking124320242diking
ding66940952d__ing
dining84525132dining
diving113717952diving
doing74923582d_oing
doling84923132doling
doming104218392doming
doping103919462doping
dosing83920272dosing
doting84821912doting
downing123811672downing
dowsing123411122dowsing
dozing174214192dozing
drawing123812052drawing
dreeing94311182dreeing
drying113411602drying
duding93913322duding
dueling93614542dueling
dueting93814392dueting
duking124715132duking
duping104113632duping
during84419402during
dwine95616142d_wine
dyeing11428212dyeing
dying105316032d_ying
dyking15458012dyking
edging93510712edging
eking106614982_eking
exing136016812_exing
eying96117922_eying
feeing104416502feeing
feting104417792feting
feuing104412272feuing
geeing84313772geeing
hawing134322352hawing
hexing174210512hexing
jawing174414962jawing
jeeing144512142jeeing
jowing174216042jowing
keying1438042keying
lawing104625282lawing
lowing104623272lowing
mawing124020802mawing
meowing1368592meowing
meting94320592meting
mewling13329512mewling
mowing124119092mowing
owing96222722_owing
pawing124519552pawing
peeing94618082peeing
reding83825562reding
redwing122811982redwing
rewin85623962rewin_
rewind104715882rewind
rewins95020822rewins
rowing103623302rowing
sawing104323812sawing
seeing74222142seeing
sering74731812sering
sewings11369172sewings
sexing144313892sexing
shewing143812192shewing
skewing15318722skewing
slewing113311352slewing
sowing104222912sowing
spewing133110452spewing
stewing113412492stewing
swing96124842_swing
tawing104521552tawing
teeing73916972teeing
towing103823192towing
vexing17479172vexing
viewing1437072viewing
vowing133715272vowing
wing86339222__wing
wowing133915392wowing
yawing134215612yawing
yowing133715542yowing

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 Filter178691825510.326548131.9
2DLD Change Limit825511352.53032628.9
3Display Results1351350.0502700.0
 (SQL Overall)1786911352.90661490.4
 
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.