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

169 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
citifies1331068(None) 
citified1438251citified
acetifies1447132acetifies
acidifies15126452acidifies
certifies14310322certifies
cities84524852cit__ies
cityfied1742702cityfied
codifies1439642codifies
lithifies1545502lithifies
minifies13312902minifies
nidifies1238232nidifies
nitrifies12107922nitrifies
notifies11310422notifies
ratifies11313512ratifies
vilifies1439592vilifies
vinifies1439872vinifies
vitrifies1547222vitrifies
vivifies1747022vivifies
acetified1545893acetified
acetifier1444863acetifier
acetifiers1543403acetifiers
acidified16104983acidified
acidifier15124383acidifier
acidifiers16113223acidifiers
acidities12810183acidities
aerifies111313393aerifies
artifices1446473artifices
basifies13310493basifies
beatifies1459283beatifies
biffies152710853bi_ffies
brutifies1445713brutifies
caitiffs1642883caitif_fs
calcifies1638923calcifies
canities101519263canities
carnifies1439893carnifies
casefies1339213casefies
catties94023053cat_ties
cavities131412613cavities
cecities12312043cecities
certified1548413certified
certifier1447353certifier
certifiers1545143certifiers
chilies124218303c_hilies
chitties13310773chit_ties
chivies153412853c_hivies
cicelies1269753cicelies
ciliates10413453ciliates
cilices113814023cili_ces
cimices13279803cimi_ces
cissies94116153ci_ssies
cites74435593cit___es
citied94014143cit__ied
citify1437443citif__y
citifying1845383citifying
citizen1845713citi_zen
citizens1943983citizens
citoles9312553cit_oles
citrates102315093citrates
citrines102513133citrines
citrinins1145583citrinins
citrins92614363cit_rins
citruses1037483citruses
civies114116443c__ivies
civilise1386263civilise
civilises14106093civilises
civilizes23115883civilizes
civvies1555843ci_vvies
clarifies1448633clarifies
cliticizes2375493cliticizes
coalifies1439113coalifies
codified1537403codified
codifier1447163codifier
codifiers1555343codifiers
coiffes1546803c_oiffes
comities12317793comities
cornifies1439003cornifies
coteries10422703coteries
cotinines11410073cotinines
criticise1356453criticise
criticises1446433criticises
criticizes2365933criticizes
critiques2042593critiques
crucifies1646123crucifies
cuticles1237893cuticles
cuties84927363cut__ies
cutinise1048763cutinise
cutinises1148513cutinises
cutinizes2047883cutinizes
cutises94414913cuti_ses
cutties93118843cut_ties
cytidines1544803cytidines
deifies113317453_deifies
dignifies1446363dignifies
dimities11314003dimities
ditties83116983dit_ties
edifies113012283_edifies
entities8617413entities
fixities1838213fixities
fortifies1548693fortifies
gasifies1238693gasifies
gratifies1347993gratifies
ignifies1277563ignifies
jiffies20327473ji_ffies
justifies1945793justifies
kitties113213623kit_ties
lignifies1346263lignifies
liquifies2144883liquifies
litanies8310993litanies
lithified1644463lithified
metrifies1439803metrifies
micrifies16118673micrifies
minified1439653minified
miticides1447083miticides
mitises9315543miti_ses
modifies1439163modifies
mortifies1439393mortifies
mutinies10311503mutinies
mystifies1745883mystifies
nazifies2036063nazifies
nidified1346763nidified
nigrifies1346363nigrifies
nitchies1339073nitchies
niteries8318383niteries
nitrified1346723nitrified
nitrifier1245963nitrifier
nitrifiers1343923nitrifiers
notified1238363notified
notifier1137423notifier
notifiers1245023notifiers
ossifies1177563ossifies
pacifies15311223pacifies
petrifies14310363petrifies
pities83828083pit__ies
purifies13311923purifies
ramifies13310503ramifies
rarifies11311933rarifies
ratified12310503ratified
ratifier1139673ratifier
ratifiers1236453ratifiers
rectifies14310813rectifies
reifies104218283_reifies
salifies11314793salifies
satisfies1245323satisfies
scarifies1439603scarifies
scorifies1448023scorifies
signifies1347063signifies
stiffies14258383stiffies
stifles103013393_stifles
stimies9316563_stimies
testifies12139263testifies
tidies74721833__tidies
titties73617363tit_ties
typifies1644963typifies
uglifies1246383uglifies
unifies102714713_unifies
untidies939813untidies
verifies141313483verifies
vilified1547243vilified
vilifier1456693vilifier
vilifiers1544563vilifiers
vinified1537543vinified
vitiates112311433vitiates
vitrified1645983vitrified
vivified1845893vivified
vivifier1745173vivifier
vivifiers1843673vivifiers
withies133913543wit_hies
zincifies2344953zincifies
zinkifies2543503zinkifies

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.450397091.1
2DLD Change Limit1461621697.03320782.3
3Display Results1691690.0762223.7
 (SQL Overall)1786911697.55923639.5
 
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.