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

105 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
dezincing224418(None) 
dezincking2741681dezincking
defencing16226692defencing
defining133711802defin_ing
dehiscing1643732dehiscing
deicing11312192de_i_cing
evincing1446182_evincing
zincing192910282__zincing
beduncing1543913beduncing
beginning1344613beginning
dancing113611563d__ancing
deairing10311893deai_ring
deaning94020473de_an_ing
debiting122511203debi_ting
deboning12109153debon_ing
debunking1733353debunking
decanting132510633decanting
deciding132210833deci_ding
declining13129353declin_ing
deducing1336423de_ducing
defacing15238683de_facing
defanging1535333defanging
defending15298353defending
defensing14217003defensing
defiling132812463defi_ling
deforcing1636063deforcing
defunding15216123defunding
deifying1637633de_ifying
deigning1137753de_igning
deliming12310373deli_ming
delisting112710503delisting
demanding14237923demanding
dementing13311043dementing
demising122012523demi_sing
demitting13239073demitting
denning93515173de__nning
denouncing1443883denouncing
denting94422183de__nting
denying123711293de__nying
depainting14156153depainting
depending14208783depending
depicting1537813depicting
deponing121211213depon_ing
deranging1238063deranging
deriding112512933deri_ding
deriving132510743deri_ving
desanding12207653desanding
designing1236623designing
desiring10312143desi_ring
desisting112810383desisting
destining11311433destin_ing
detaining112510473detain_ing
deticking1736043deticking
deucing1139393de__ucing
deveining1436393devein_ing
deviating14311083deviating
deviling1311812853devi_ling
devilling1436703devilling
devising133111523devi_sing
devoicing16145223devoicing
dezinc1836053dezinc___
dezinced2183903dezinc_ed
dezincked2691643dezincked
dezincs1933753dezinc__s
dicing105718763d__i_cing
dinging103618613d__inging
dining84525133d__in_ing
dinking133618283d__inking
dinning93416553d__inning
dinting93520553d__inting
discing113914593d__iscing
divining1338413divin_ing
dizening19177143dizen_ing
dozening19236183dozen_ing
draining103312673drain_ing
drinking14308913d_rinking
dwining12269293d_win_ing
feinting123410833fe_inting
fencing132411133fe__ncing
mincing123314333__mincing
peining104619153pe_in_ing
penancing1436343penancing
rebinding13249483rebinding
refencing15188853refencing
refinding14259943refinding
refining122416863refin_ing
rehinging1437453rehinging
reining84425323re_in_ing
reinking13311023re_inking
relining93218743relin_ing
relinking1458253relinking
reminding132311543reminding
reminting122315103reminting
repining114116593repin_ing
repinning12258973repinning
resining92919553resin_ing
retinting102215253retinting
rewinding14238933rewinding
rewinning13257443rewinning
rezoning18310453rezon_ing
seining84020773se_in_ing
veining114713893ve_in_ing
wincing133413903__wincing
zincking2435463__zincking
zinging183513943__zinging

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.420425454.8
2DLD Change Limit1486411056.70322175.3
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.16924925.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.