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

72 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
dandifies147689(None) 
dandified1555551dandified
damnifies1545542damnifies
dandies94121442dand__ies
densifies1347992densifies
fancifies1767082fancifies
acidifies15126453acidifies
aerifies111313393_aerifies
bandies104124863band__ies
banditries1345343banditries
basifies13310493ba_sifies
calcifies1638923calcifies
candies104125613cand__ies
canities101519263can_ities
carnifies1439893carnifies
codifies1439643_codifies
dacoities1248213dacoities
daddies103414943da_d_dies
dailies84219263da__ilies
dairies84217733da__iries
daisies84217093da__isies
dakoities1444673dakoities
damnified1644883damnified
dandier93714573dand__ier
dandiest103415033dand__iest
dandify15245673dandif__y
dandifying1974313dandifying
dandles94218533dand__les
dandriffs1792313dandrif_fs
danishes121710493dan_ishes
daylilies1343123daylilies
deacidifies1852643deacidifies
deifies113317453d__eifies
denazifies2343293denazifies
densified1446713densified
densities10310793densities
dignifies1446363dignifies
dulcifies1545273dulcifies
edifies113012283__edifies
falsifies1545983falsifies
fancified1865793fancified
gasifies1238693ga_sifies
identifies1445803identifies
ignifies1277563ign_ifies
lapidifies1643533lapidifies
magnifies1547283magnifies
mandibles1445543mandibles
minifies13312903min_ifies
modifies1439163_modifies
nancified1565543nancified
nazifies2036063na_zifies
nidifies1238233_nidifies
pacifies15311223pa_cifies
pandies104224503pand__ies
quantifies2244753quantifies
ramifies13310503ra_mifies
randies84225663rand__ies
rarifies11311933ra_rifies
ratifies11313513ra_tifies
reedifies1347323reedifies
salifies11314793sa_lifies
salsifies1247253salsifies
sanctifies1554983sanctifies
sandflies1346513sandflies
sanities81219773san_ities
tackifies1845783tackifies
tantivies1247103tantivies
unifies102714713_un_ifies
vanities111414493van_ities
vinifies1439873vin_ifies
zincifies2344953zincifies
zinkifies2543503zinkifies

Search took 7 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.1531167915.0
2DLD Change Limit148641726.62622433.0
3Display Results72720.0302400.0
 (SQL Overall)178691726.80926243.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.