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

103 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
magnify163453(None) 
carnify1555882carnify
damnify1643452damnify
dignify1543892dignify
ignify1334512_ignify
lignify1443792lignify
magnific1654212magnific
mangily1339752mangily
minify1439252m_inify
signify1444852signify
aerify122810113_aerify
agnize16329563_agnize
amenity1238333amenity
aminity12310513aminity
ammonify1843353ammonify
amplify1744083amplify
baggily1436043baggily
bagnio937523bagni_o
bagnios1036073bagnios
basify1437513ba_sify
cagily12411563cag_ily
calcify1735873calcify
cannily1239263cannily
cornify1536253cornify
dandify15245673dandify
dignity1236463dignity
falsify1643613falsify
fancify1834983fancify
gasify1336333ga_sify
maggoty1444013maggoty
magi76329533mag_i__
magian9312833mag_ian
magic105818663mag_i_c
magics115311613mag_ics
magilp1137613mag_ilp
magnate10512703magnate
magnet9320663magn_et
magneto1046743magneto
magnets10311143magnets
magnifico1762573magnifico
magnified1645763magnified
magnifier1545273magnifier
magnifies1547283magnifies
magnifying2044033magnifying
magnum1136733magn_um
magnums1234683magnums
magpie1139093magpi_e
magpies12310363magpies
maguey1236833mag_uey
mainly11411493main_ly
malignity1543653malignity
mangaby1535353mangaby
mangey123614533ma_ngey
mangier104114063mangier
mangy115021253ma_n_gy
mania75634153ma_ni_a
maniac103917973ma_niac
manias84029033ma_nias
manic94629443ma_ni_c
manics103919933ma_nics
manila84518303ma_nila
manioc103914823ma_nioc
manito8518693ma_nito
manitu8315823ma_nitu
manlily1238743manlily
manly105022953ma_n_ly
manning103616383manning
mannish121710703mannish
mannite9312903mannite
many95731863ma_n__y
massif11412533massif_
massifs1237743massifs
mastiff1538163mastiff
maundy12506783maun_dy
mazily20610393ma_zily
metrify1535623metrify
micrify1744693micrify
modify1537173m_odify
mollify1555503mollify
moonily1248943moonily
mortify1536223mortify
muggily1435103muggily
mummify1643333mummify
mystify1843563mystify
nazify2134233na_zify
nigrify1444133nigrify
pacify1667473pa_cify
rainily10310433rainily
ramify14268753ra_mify
rarify123210063ra_rify
ratify122610043ra_tify
reunify1344453reunify
salify12311373sa_lify
salsify1334703salsify
sanity9316203sa_nity
saponify1644183saponify
tackify1934493tackify
tawnily1335443tawnily
uglify1333913_uglify
unify113611113__unify
vanity12311943va_nity
vinify1536923_vinify
zanily18310183za_nily

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271036.30021274.1
3Display Results1031030.0303433.3
 (SQL Overall)1786911036.73326539.6
 
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.