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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
deadeners114628(None) 
deadener1036741deadener_
deadened1137232deadene_d
deadens93410692deaden__s
deadeyes1344562deadeye_s
deadness1039232dead_ness
deepeners1244522deepeners
weakeners1644162weakeners
awakeners1643093awakeners
beaders104120183bead__ers
beadiness12249233beadiness
broadeners1383653broadeners
burdeners1245063burdeners
cheapeners1743113cheapeners
damners104112113d_a_mners
dampeners1444663dampeners
darkeners1435153darkeners
darners83815773d_a_rners
deaconess1245543deaconess
deaden83714323deaden___
deadening1277583deadening
deadenings1393323deadenings
deader84220473dead__er_
deadeye1245163deadeye__
deadlier1036863deadlier_
deadlines11138503deadline_s
deadliness12115893deadliness
deadpanners1571353deadpanners
deafened1335853deafene_d
deafens11317253deafen__s
deafness1236213dea_fness
dealers84118613dea__lers
deanery1137613dea__nery
dearness939973dea_rness
deboners11268113de_boners
decadences1665143decadences
decadents1346393decaden_ts
decameters15156593decameters
decenters122410373de_centers
decliners12358613decliners
decreers11277623decre_ers
deepener1145183deepener_
defenders1436363de_fenders
definers124211193de_finers
degenders1236083de_genders
dehorners1344743dehorners
dejeuners1742443dejeuners
dekameters17164863dekameters
denseness1046863denseness
depleters12327543depleters
descenders1445453descenders
designers1136003designers
detainers10269103detainers
dewaterers1442933dewaterers
diameters1247603diameters
dodderers1243803dodderers
drainers92811253dra_iners
earners74016453_ea_rners
eveners10109503_e_veners
gardeners1136603gardeners
gladdeners1352063gladdeners
hardeners1338083hardeners
headends13326723headen_ds
headers113819393head__ers
headiness132510363headiness
headliners14144333headliners
hearkeners1743983hearkeners
hearteners1346213hearteners
keeners113610783ke__eners
leadened1036153leadene_d
leadenness1144443leadenness
leadens83610983leaden__s
leaders83819603lead__ers
leaners73718173lea__ners
learners8398153lea_rners
meanderers1343803meanderers
meaners94415243mea__ners
raveners11309133_raveners
readers83823773read__ers
readiness102611853readiness
reasoners947113reasoners
renderers10208093renderers
seasoners946263seasoners
teaselers9165853teaselers
teeners74415453te__eners
tenderers10227803tenderers
verderers1344843verderers
wakeners1535843_wakeners
weakener1534913weakener_
weaners104613833wea__ners
wideners12257993_wideners
yearners11346373yea_rners

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.453394461.4
2DLD Change Limit148641927.36020195.8
3Display Results92920.0462000.0
 (SQL Overall)178691927.85922737.1
 
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.