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

122 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
citified143825(None) 
citifies13310681citifies
cityfied1742701cityfied
acetified1545892acetified
acidified16104982acidified
certified1548412certified
citied94014142cit__ied
codified1537402codified
lithified1644462lithified
minified1439652minified
nidified1346762nidified
nitrified1346722nitrified
notified1238362notified
ratified12310502ratified
vilified1547242vilified
vinified1537542vinified
vitrified1645982vitrified
vivified1845892vivified
acetifier1444863acetifier
acetifies1447133acetifies
acidifier15124383acidifier
acidifies15126453acidifies
aerified121310133aerified
basified1437823basified
beatified1577863beatified
bikinied1543513bikinied
brutified1544773brutified
calcified1746893calcified
carnified1547293carnified
casefied1445943casefied
cavitied14126813cavitied
certifier1447353certifier
certifies14310323certifies
chivied16368383c_hivied
ciliated11510953ciliated
cited84421953cit___ed
cities84524853cit__ies
citify1437443citif__y
citifying1845383citifying
citizen1845713citi_zen
citrated112712253citrated
citywide1741783citywide
civilised1584613civilised
civilized24105493civilized
clarified1546973clarified
cliticized2454643cliticized
coalified1546813coalified
codifier1447163codifier
codifies1439643codifies
coifed124113063c_oif_ed
coiffed1635413c_oiffed
cornified1546623cornified
criticised1564193criticised
criticized2454983criticized
critiqued2141953critiqued
crucified1744683crucified
cutinised1245913cutinised
cutinized2146913cutinized
deified123112413_deified
dignified1545573dignified
edified12339713_edified
fortified1646503fortified
gasified1336533gasified
gratified1446253gratified
humified1745653humified
ignified1386213ignified
justified2045043justified
lignified1445063lignified
liquified2244283liquified
lithifies1545503lithifies
metrified1547853metrified
micrified17126793micrified
minifies13312903minifies
miticide1347863miticide
modified1537273modified
mortified1547383mortified
mutinied1148163mutinied
mystified1845083mystified
nazified2144993nazified
nidifies1238233nidifies
nigrified1445323nigrified
nitrifier1245963nitrifier
nitrifies12107923nitrifies
notifier1137423notifier
notifies11310423notifies
ossified1276433ossified
pacified1638363pacified
petrified1548333petrified
pitied94017253pit__ied
purified1438743purified
ramified1438043ramified
rarified1239053rarified
ratifier1139673ratifier
ratifies11313513ratifies
rectified1539243rectified
reified112913783_reified
salified12310363salified
satisfied1343873satisfied
scarified1547293scarified
scorified1546193scorified
signified1446043signified
sissified1345543sissified
stiffed14359583_stiffed
stifled113511093_stifled
stimied10310623_stimied
testified1397843testified
tidied83613273__tidied
tiffed13368393__tiffed
typified1743923typified
uglified1345293uglified
unified112413573_unified
untidied1038903untidied
verified151510393verified
vilifier1456693vilifier
vilifies1439593vilifies
vinifies1439873vinifies
vitiated12289223vitiated
vitrifies1547223vitrifies
vivifier1745173vivifier
vivifies1747023vivifies
zincified2444293zincified
zinkified2643163zinkified

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.420425454.8
2DLD Change Limit1461621227.78018786.9
3Display Results1221220.0631936.5
 (SQL Overall)1786911228.26321625.4
 
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.