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 “declining” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
declining1312935(None) 
reclining121112281reclining
beelining1236592beelining
deadlining1364562deadlining
deceiving1635732deceiving
decerning1337292decerning
deciding132210832dec_iding
declaiming1644782declaiming
declaring1339572declaring
declawing1636212declawing
declinist1247652declinist
defining133711802de_fining
deliming12310372de_liming
deplaning1338052deplaning
destining11311432destining
detaining112510472detaining
deveining1436392deveining
inclining1248402inclining
recoining121313802recoining
redlining111210292redlining
relining93218742re_lining
alining81917043__alining
beckoning1845773beckoning
beclowning1843423beclowning
becriming1646363becriming
besliming1435493besliming
bylining1446013_bylining
calcining1447813calcining
chining133316843__chining
clinging122910913__clinging
clinking153611663__clinking
cloning103215473__cloning
coining103920543__coining
cyclizing2645633cyclizing
datelining1244363datelining
deaconing1337193deaconing
deadening1277583deadening
deafening1476273deafening
deairing10311893de_airing
dealing94323233deal__ing
deaning94020473de__aning
debiting122511203de_biting
deboning12109153de_boning
debriding1446483debriding
decamping1734943decamping
decanting132510633decanting
decaying15239453dec_aying
deceasing1338403deceasing
decisioning1543933decisioning
decking153915593dec__king
declassing1445123declassing
decline103716613decl__ine
declined123910883declin_ed
decliner113710843declin_er
decliners12358613decliners
declines113315803declin_es
declinists1344363declinists
declivity1844483declivity
decocting1538123decocting
decoding132410053dec_oding
decoloring1486313decoloring
decoying15208763dec_oying
decreeing1335523decreeing
decrowning1743593decrowning
decrying15237413dec_rying
decupling1534973decupling
decurving1634723decurving
deepening1335613deepening
defiling132812463de_filing
deflating142610713deflating
defleaing1444743defleaing
deglazing2135133deglazing
dehorning1455243dehorning
deicing11312193de__icing
deigning1137753de_igning
delating103119603de_lating
delaying133210973de_laying
deleing93313953de_l_eing
deleting103314423de_leting
delisting112710503de_listing
deluding1137683de_luding
deluging1137123de_luging
delving123711573de_l_ving
demeaning1337243demeaning
demising122012523de_mising
denning93515173de__nning
depainting14156153depainting
depleting1378193depleting
deploring1337853deploring
deploying1636153deploying
depluming1544713depluming
deponing121211213de_poning
depriving1636403depriving
deraigning1344103deraigning
derailing112011313derailing
deriding112512933de_riding
deriving132510743de_riving
describing1645073describing
designing1236623designing
desiring10312143de_siring
despising13167503despising
despiting13179323despiting
destaining1267943destaining
detailing112510413detailing
detraining1267673detraining
deviling1311812853de_viling
devilling1436703devilling
devising133111523de_vising
devoicing16145223devoicing
dezincing2244183de_zincing
diclinies1247833diclinies
diclinism1445223diclinism
dining84525133d___ining
disliking1537313disliking
dislimning1444883dislimning
divining1338413d_ivining
draining103312673d_raining
dualizing2047783dualizing
dwining12269293d__wining
eclipsing1443743_eclipsing
eliding93414343_e_liding
eloining9310443_eloining
engining1039293_engining
headlining1553773headlining
idealising1245703idealising
idealizing2147293idealizing
inclinings1343263inclinings
lining74526803___lining
machining1746933machining
meclizine2244123meclizine
outlining10310503outlining
pectizing2348013pectizing
peining104619153pe__ining
realigning1245933realigning
realising10313173realising
realizing19313813realizing
recaning111416693rec_aning
receiving1538993receiving
reciting113118073rec_iting
reckoning1637643reckoning
reclaiming1546583reclaiming
recleaning1336753recleaning
recoiling121412413recoiling
reconning121410793reconning
redlinings12132793redlinings
refining122416863re_fining
regaining112411083regaining
reining84425323re__ining
rejoining17149223rejoining
relinking1458253re_linking
reliving122713343re_living
remaining122212793remaining
repining114116593re_pining
reshining13310743reshining
resining92919553re_sining
retaining102114733retaining
secerning1246203secerning
secluding1344143secluding
sectioning1346293sectioning
seining84020773se__ining
sequining1945323sequining
sidelining1244573side_lining
splining11310773_splining
underlining1346683underlining
veining114713893ve__ining

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411657.47019898.4
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.95322468.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.