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

161 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
dealing9432323(None) 
dealings103510701dealings
deaning94020471deaning
deaving123814751deaving
dialing94318171dialing
healing113922961healing
pealing104123201pealing
sealing83528561sealing
vealing114217421vealing
yealing112716381yealing
baling94829692_baling
beading113221862beading
beaming123618802beaming
beaning103820682beaning
bearing103624772bearing
beating104326872beating
belling103825072belling
ceasing104118262ceasing
ceiling103416722ceiling
celling103921262celling
coaling103722822coaling
daring84928682d_aring
darling93418362darling
dating85326482d_ating
dawing114819822d_awing
dazing175516512d_azing
deadline10139052deadline
deairing10311892deairing
deashing134210952deashing
debasing12238062debasing
debating123213732debating
decaying15239452decaying
decking153915592decking
decline103716612decline
deeding103315122deeding
deeming113913122deeming
defacing15238682defacing
defaming15238462defaming
defiling132812462defiling
defying15328822defying
deicing11312192deicing
dekeing13358352dekeing
deking125614552de_king
delaine8314792delaine
delating103119602delating
delaying133210972delaying
deleing93313952deleing
delving123711572delving
demoing11311752demoing
denning93515172denning
denting94422182denting
denying123711292denying
derailing112011312derailing
derating103222282derating
desalting1138842desalting
detailing112510412detailing
deucing1139392deucing
devaluing1434832devaluing
develing133212732develing
deviling1311812852deviling
dewaxing20215292dewaxing
dewing114115702de_wing
dialings10329822dialings
dialling10310782dialling
dirling93316072dirling
doating93816862doating
doling84923132d_oling
dolling93817372dolling
draping114213352draping
drawing123812052drawing
drawling13318672drawling
draying123813842draying
dreading113712802dreading
dreaming124011062dreaming
dueling93614542dueling
duelling103410732duelling
dulling93418272dulling
dwelling13368412dwelling
eagling91113602_eagling
eanling81416672_eanling
earing75235482_earing
easing74926462_easing
eating75134402_eating
fearing113520032fearing
feasing113916652feasing
feazing205411442feazing
feeling113617072feeling
felling113321132felling
foaling113515842foaling
gearing92818842gearing
gelling93219762gelling
goaling93515332goaling
haling104229782_haling
heading122919112heading
heaping133015852heaping
hearing113324162hearing
heating114024322heating
heaving144114762heaving
heeling113618512heeling
heiling113616362heiling
helling114623222helling
ideating10311702ideating
jelling153516612jelling
keeling123515122keeling
kegling13309362kegling
leading93419552leading
leafing113313582leafing
leaking123616972leaking
leaning83721202leaning
leaping103215992leaping
leasing83920162leasing
leaving114216852leaving
meaning103918702meaning
medaling121912262medaling
melling102822622melling
metaling111613722metaling
mewling13329512mewling
nearing83020332nearing
paling93530132_paling
peacing124117072peacing
peaking144317692peaking
pearling11912012pearling
pedaling122412132pedaling
peeling102919872peeling
reading93327212reading
realign838762realign
reaming103924012reaming
reaping103621212reaping
rearing83128782rearing
reaving113820532reaving
reeling83126862reeling
regaling10315362regaling
scaling103519372scaling
seaming103222112seaming
searing83330922searing
seating84130682seating
seeling83522002seeling
selling83225832selling
shealing123415462shealing
staling83925422staling
stealing93416602stealing
teaming103917592teaming
tearing84021492tearing
teasing83918512teasing
teazling1856572teazling
telling83321082telling
veiling113615292veiling
vialing113614162vialing
waling104525302_waling
weakling16106762weakling
weaning114117192weaning
weanling12118642weanling
wearing113318862wearing
weaving143211622weaving
welling112920312welling
whaling143910772whaling
yealings12257702yealings
yeaning113814632yeaning
yeanling12107062yeanling
yearling1297882yearling
yelling113516702yelling

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711613.37331921.4
3Display Results1611610.0632555.6
 (SQL Overall)1786911613.81246875.9
 
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.