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

132 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
dandify1524567(None) 
dandily12279631dandily
damnify1643452damnify
dandier93714572dandier
dandies94121442dandies
dandriff1694172dandriff
dandy104416702dand__y
densify1435292densify
fancify1834982fancify
handily143610872handily
acidify1645243acidify
aerify122810113_aerify
bandied114414303bandied
bandies104124863bandies
banding114921413banding
bandit93821133bandi_t
bandito103710043bandito
banditry1444123banditry
bandits103814793bandits
bandy114824193band__y
basify1437513ba_sify
bawdily1635803bawdily
calcify1735873calcify
candid104517853candi_d
candida114110253candida
candidly1545213candidly
candids113812693candids
candied113816023candied
candies104125613candies
candy115119823cand__y
cannily1239263cannily
carnify1555883carnify
codify1537163_codify
dacoity1366183dacoity
daddies103414943daddies
daddy116212563da_d_dy
daffily1735143daffily
daffy155510283da__ffy
daily95922333da__ily
daintily1245523daintily
dairy97016303da__iry
daisy95915313da__isy
dakoity1543423dakoity
dancing113611563dancing
dander811222993dand_er
danders93921183danders
dandiest103415033dandiest
dandified1555553dandified
dandifies1476893dandifies
dandifying1974313dandifying
dandle84218093dand_le
dandled103313543dandled
dandler94414273dandler
dandles94218533dandles
dandling112511733dandling
dandriffs1792313dandriffs
dandruff1692513dandruff
dandruffy20101103dandruffy
dandyish1644723dandyish
dandyism1543943dandyism
danging103716093danging
dangly114212273dan_gly
danio6319783dan_i_o
danios7314603dan_ios
danish101513813dan_ish
dankly14419463dan_kly
daylily1434983daylily
deacidify1942123deacidify
deify124112763d__eify
denazify2442533denazify
density1137593density
dignify1543893dignify
dingily1238103dingily
dowdily1534953dowdily
dulcify1643023dulcify
edify12308563__edify
falsify1643613falsify
fancily1538253fancily
gasify1336333ga_sify
gaudily1236523gaudily
handier113817443handier
handing123518893handing
handoff1756483handoff
handy125520873hand__y
hardily143310273hardily
identify1544133identify
ignify1334513ign_ify
landing92819323landing
lankily1437123lankily
lapidify1742803lapidify
magnify1634533magnify
mangily1339753mangily
manlily1238743manlily
minify1439253min_ify
modify1537173_modify
nandin7313033nandi_n
nandina838913nandina
nandins8312003nandins
nazify2134233na_zify
nidify1336763_nidify
pacify1667473pa_cify
pandied113913443pandied
pandies104224503pandies
pandit93820753pandi_t
pandits103914213pandits
pandy115021173pand__y
quantify2343863quantify
ramify14268753ra_mify
randier83618473randier
randies84225663randies
randy95022083rand__y
rarify123210063ra_rify
ratify122610043ra_tify
reedify1465763reedify
salify12311373sa_lify
salsify1334703salsify
sanctify1644493sanctify
sandfly1435643sandfly
sandier84017843sandier
sanding93520603sanding
sandy94221133sand__y
sanity9316203san_ity
tackify1934493tackify
tantivy1335563tantivy
tardily11269583tardily
unify113611113_un_ify
vanity12311943van_ity
vinify1536923vin_ify
windily1437943windily
zanily18310183zan_ily
zincify2443913zincify
zinkify2643123zinkify

Search took 10 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 Filter1786911340270.436409841.7
2DLD Change Limit1340271328.76615289.4
3Display Results1321320.0632095.2
 (SQL Overall)1786911329.26519286.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.