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

152 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
modifies143916(None) 
codifies1439641codifies
modified1537271modified
modifier1446701modifier
modifiers1584481modifiers
codified1537402codified
codifier1447162codifier
codifiers1555342codifiers
edifies113012282_edifies
minifies13312902minifies
modistes1138642modistes
mollifies1447552mollifies
mortifies1439392mortifies
nidifies1238232nidifies
notifies11310422notifies
remodifies16116022remodifies
acidifies15126453acidifies
aerifies111313393aerifies
ammonifies17104083ammonifies
amplifies16106703amplifies
basifies13310493basifies
bodices12710593bodi_ces
bodies94524143bod__ies
citifies13310683citifies
coalifies1439113coalifies
codices12512583codi_ces
codicils1346043codicils
coiffes1546803co_iffes
comities12317793comities
commodifies2153143commodifies
cornifies1439003cornifies
dandifies1476893dandifies
defies104624053__defies
deifies113317453_deifies
didies84621833__didies
doilies84017363do_ilies
dominies113513193dominies
edifices1454863_edifices
edified12339713_edified
edifier11309263_edifier
edifiers12336673_edifiers
fortifies1548693fortifies
gasifies1238693gasifies
glorifies1346363glorifies
homilies132710113homilies
hominies133012953hominies
horrifies15146393horrifies
humidifies1943553humidifies
ignifies1277563ignifies
iodides93811613iodi_des
iodines83616633iodi_nes
iodises83413633iodi_ses
iodizes173911723iodi_zes
jollifies1945553jollifies
magnifies1547283magnifies
medflies1435553medflies
mediacies1447183mediacies
mediates112814063mediates
medicides1556583medicides
medicines1447903medicines
meinies92516073m_einies
metrifies1439803metrifies
micrifies16118673micrifies
middies113116153mid_dies
midwifes17234713midwif_es
minified1439653minified
mobiles112813123mobi_les
mobilise1248143mobilise
mobilises1347513mobilises
mobilizes2247423mobilizes
modalities13138813modalities
modernes1138423modernes
modes85537413mod___es
modesties1247473modesties
modicums1543483modicums
modify1537173modif__y
modifying1944663modifying
modiolus1143773modiolus
modiste1039283modiste_
modules102511003mod_ules
moggies113111723mo_ggies
moidores1156343moidores
moieties10311263moieties
moires8915633mo_i_res
molies84429513mo__lies
mollies93420233mo_llies
mollified1545653mollified
mollifier1445163mollifier
mollifiers1543993mollifiers
mommies103912273mo_mmies
monies83233163mo__nies
monishes13311483monishes
monodies11312503monodies
monofils1346963monofils
moperies12313873moperies
mortified1547383mortified
mortifier1446923mortifier
mortifiers1544403mortifiers
motific1446323motifi_c
motifs1139673motif__s
motiles93317433moti_les
motives123611893moti_ves
movies115118453mo__vies
moxies154317403mo__xies
muddies113513953mud_dies
mummifies1543713mummifies
mutinies10311503mutinies
mystifies1745883mystifies
nazifies2036063nazifies
nidified1346763nidified
noddies93512043nod_dies
notified1238363notified
notifier1137423notifier
notifiers1245023notifiers
nudities939683nudities
oddities1046603oddities
orifices1346483_orifices
ossifies1177563ossifies
pacifies15311233pacifies
podites103014733podi_tes
policies122415663policies
polities102722343polities
premodifies19114223premodifies
prodigies1346953prodigies
purifies13311933purifies
ramifies13310503ramifies
rarifies11311943rarifies
ratifies11313513ratifies
recodifies16106323recodifies
redefies12710163redefies
reedifies1347323reedifies
reifies104218283_reifies
remodified17115263remodified
roofies103014413ro_ofies
salifies11314793salifies
scorifies1448023scorifies
soddies92312853sod_dies
sodomies11128553sodomies
solidifies1445323solidifies
toddies93011993tod_dies
todies74223553tod__ies
toffies133210213to_ffies
torrifies12137033torrifies
typifies1644963typifies
uglifies1246383uglifies
unifies102714713_unifies
unmodified1742903unmodified
verifies141313483verifies
vilifies1439593vilifies
vinifies1439873vinifies
vivifies1747023vivifies
zombifies2543213zombifies

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621528.28017652.4
3Display Results1521520.0801900.0
 (SQL Overall)1786911528.81320275.8
 
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.