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

84 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
fancifies176708(None) 
fancified1865791fancified
calcifies1638922calcifies
dandifies1476892dandifies
falsifies1545982falsifies
fancies124018782fanc__ies
nancified1565542nancified
pacifies15311232pa_cifies
sanctifies1554982sanctifies
zincifies2344952zincifies
accidies1338043_accidies
aerifies111313393_aerifies
basifies13310493ba_sifies
calcified1746893calcified
canities101519263can_ities
carnifies1439903carnifies
crucifies1646123crucifies
damnifies1545543damnifies
dandified1555553dandified
densifies1347993densifies
dulcifies1545273dulcifies
facies113921593fa_c__ies
fairies103516043fa__iries
falsified1644983falsified
falsifier1544433falsifier
falsifiers1643233falsifiers
falsities1248133falsities
families1339443fa_milies
fancied133310603fanc__ied
fancier123412063fanc__ier
fanciers13358083fanci_ers
fanciest133612713fanc__iest
fanciful1643943fancif_ul
fancify1834983fancif__y
fancifying2243883fancifying
fanciless1444603fanciless
fanciness1437673fanciness
fanfics1535173fan__fics
fannies103415643fan__nies
fantasies1298853fantasies
fanzines2036913fanzi_nes
farcies125317883farc__ies
fascicles1664263fascicles
fascines13310143fasci_nes
fascitis1346013fasciti_s
fascitises1544743fascitises
fatuities1246913fatuities
fencibles1644093fencibles
fortifies1548693fortifies
francizes2346793franci_zes
frenchifies2252863frenchifies
fructifies1843223fructifies
gasifies1238693ga_sifies
ignifies1277563ign_ifies
magnifies1547283magnifies
manciples1564793manciples
minifies13312903min_ifies
nancies93516843nanc__ies
nazifies2036063na_zifies
opacifies1645463opacifies
pacified1638363pa_cified
pacifier1557503pa_cifier
pacifiers1645473pa_cifiers
paucities1348503paucities
quantifies2244753quantifies
ramifies13310503ra_mifies
rarifies11311943ra_rifies
ratifies11313513ra_tifies
raucities1148163raucities
salifies11314793sa_lifies
salsifies1247253salsifies
sanctified1644293sanctified
sanctifier1553493sanctifier
sanctifiers1652373sanctifiers
sanctities1247553sanctities
sanities81219773san_ities
specifies1647573specifies
tackifies1845783tackifies
tantivies1247103tantivies
unifies102714713_un_ifies
vanities111414493van_ities
vinifies1439873vin_ifies
zincified2444293zincified
zinkifies2543503zinkifies

Search took 9 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 Limit148641847.67319372.0
3Display Results84840.0302800.0
 (SQL Overall)178691848.15621909.1
 
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.