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

190 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
codifies143964(None) 
codified1537401codified
codifier1447161codifier
codifiers1555341codifiers
modifies1439161modifies
acidifies15126452acidifies
citifies13310682citifies
coalifies1439112coalifies
codices12512582codi_ces
codicils1346042codicils
coiffes1546802co_iffes
comities12317792comities
cornifies1439002cornifies
edifies113012282_edifies
modified1537272modified
modifier1446702modifier
modifiers1584482modifiers
nidifies1238232nidifies
notifies11310422notifies
recodifies16106322recodifies
scorifies1448022scorifies
acetifies1447133acetifies
acidified16104983acidified
acidifier15124383acidifier
acidifiers16113223acidifiers
acidities12810183acidities
aerifies111313393aerifies
basifies13310493basifies
bodices12710593bodi_ces
bodies94524143bod__ies
caddies113718383cad_dies
calcifies1638923calcifies
canities101519263canities
carnifies1439893carnifies
casefies1339213casefies
cavities131412613cavities
cecities12312043cecities
certifies14310323certifies
chilies124218303c_hilies
chivies153412853c_hivies
cities84524853c__ities
citified1438253citified
civies114116443c__ivies
clarifies1448633clarifies
coalified1546813coalified
coddles114213593cod_dles
codeias103911223cod_eias
codeines113114523codeines
codeins103715483cod_eins
coderives1547483coderives
codes86247293cod___es
codfish1637163cod_fish
codfishes1845643codfishes
codicil1246813codici_l
codify1537163codif__y
codifying1944953codifying
codlins104116243cod_lins
codpieces1643803codpieces
codrives1437663codrives
coffees15329573co_ffees
coffins153110193co_ffins
coffles152610003co_ffles
coifed124113063co_if_ed
coiffe1447043co_iffe_
coiffed1635413co_iffed
coifing133213893co_ifing
coifs105718703co_if__s
coignes103912153co_ignes
colicines13311203colicines
colicins12312853colicins
colies84837053co__lies
colitis92617353coliti_s
colitises11311743colitises
collies94326583co_llies
colonies103620013colonies
comedies13311843comedies
comfier1439163co_mfier
comfiest1539133co_mfiest
comfits14328743co_mfits
commies133718453co_mmies
commodifies2153143commodifies
complies14314523complies
conchies153214853conchies
confides14310573confides
confines13315653confines
confits122811423co_nfits
conies84338593co__nies
conifer123212643conif_er
conifers133611703conifers
coniines10415363coniines
conines93827793coni_nes
conioses10313313conioses
cookies133719273co_okies
coolies93824963co_olies
coonties10513803coonties
cooties93725733co_oties
copies104130303co__pies
copihues1543993copihues
copurifies1754363copurifies
corbies113520123co_rbies
cordites11314623cordi_tes
cornified1546623cornified
corodies11313693corodies
corries94026793co_rries
cosies84932153co__sies
cosines94122673cosi_nes
coteries10422703coteries
cotinines11410073cotinines
counties10316283counties
covaries13413253covaries
cowpies143314283co_wpies
cowries124218013co_wries
coxitides1945113coxitides
coxitis16238463coxiti_s
cozies174521413co__zies
crucifies1646123crucifies
crudities1247743crudities
cuddies113313263cud_dies
dandifies1476893dandifies
defies104624053__defies
deifies113317453_deifies
didies84621833__didies
doilies84017363do_ilies
dominies113513193dominies
edifices1454863_edifices
edified12339713_edified
edifier11309263_edifier
edifiers12336673_edifiers
fortifies1548693fortifies
gasifies1238693gasifies
glorifies1346363glorifies
homilies132710113homilies
hominies133012953hominies
horrifies15146393horrifies
ignifies1277563ignifies
iodides93811613iodi_des
iodines83616633iodi_nes
iodises83413633iodi_ses
iodizes173911723iodi_zes
jollifies1945553jollifies
minifies13312903minifies
modistes1138643modistes
mollifies1447553mollifies
mortifies1439393mortifies
nazifies2036063nazifies
nidified1346763nidified
noddies93512043nod_dies
notified1238363notified
notifier1137423notifier
notifiers1245023notifiers
nudities939683nudities
oddities1046603oddities
orifices1346483_orifices
ossifies1177563ossifies
pacifies15311223pacifies
podites103014733podi_tes
policies122415663policies
polities102722343polities
prodigies1346953prodigies
purifies13311923purifies
ramifies13310503ramifies
rarifies11311933rarifies
ratifies11313513ratifies
recodified1765533recodified
redefies12710163redefies
reedifies1347323reedifies
reifies104218283_reifies
remodifies16116023remodifies
roofies103014413ro_ofies
salifies11314793salifies
scarifies1439603scarifies
scorified1546193scorified
scorifier1445413scorifier
scorifiers1543603scorifiers
soddies92312853sod_dies
sodomies11128553sodomies
solidifies1445323solidifies
toddies93011993tod_dies
todies74223553tod__ies
toffies133210213to_ffies
torrifies12137033torrifies
typifies1644963typifies
uglifies1246383uglifies
uncodified1743393uncodified
unifies102714713_unifies
verifies141313483verifies
vilifies1439593vilifies
vinifies1439873vinifies
vivifies1747023vivifies
zombifies2543213zombifies

Search took 8 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.423422437.4
2DLD Change Limit1461621907.12320519.7
3Display Results1901900.0762500.0
 (SQL Overall)1786911907.62223444.1
 
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.