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

124 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
codifier144716(None) 
codified1537401codified
codifiers1555341codifiers
codifies1439641codifies
modifier1446701modifier
acidifier15124382acidifier
comfier1439162co_mfier
conifer123212642conif_er
edifier11309262_edifier
modified1537272modified
modifiers1584482modifiers
modifies1439162modifies
notifier1137422notifier
scorifier1445412scorifier
acetifier1444863acetifier
acidified16104983acidified
acidifiers16113223acidifiers
acidifies15126453acidifies
basifier1337313basifier
certifier1447353certifier
chaffier1935473chaffier
chuffier1934543chuffier
citified1438253citified
citifies13310683citifies
clarifier1446123clarifier
cliffier1633913cliffier
cloddier1234063clod_dier
coalier93416183co_alier
coalified1546813coalified
coalifies1439113coalifies
cobbier133410163co_bbier
cockier154013623co_ckier
codder104416343cod__der
coddler113710833cod_dler
coder86134223cod___er
codfish1637163cod_fish
codger105814873cod__ger
codices12512583codi_ces
codicil1246813codici_l
codicils1346043codicils
codify1537163codif__y
codifying1944953codifying
codriver1435913codriver
coffer144112863co__ffer
coifed124113063co_if_ed
coiffe1447043co_iffe_
coiffed1635413co_iffed
coiffes1546803co_iffes
coiffeur1642153co_iffeur
coifing133213893co_ifing
coiler84421593co_i_ler
coiner84323783co_i_ner
coinfer12419393co_infer
cointer93616723co_inter
colickier1743513colickier
collier93618153co_llier
comelier12310653comelier
comities12317793comities
complier14310253complier
confer114018683co_nf_er
confider1438123confider
confiner13311193confiner
conifers133611703conif_ers
copier103722893co__pier
corkier133114303co_rkier
cornier93017093co_rnier
cornified1546623cornified
cornifies1439003cornifies
cosier84423753co__sier
cosigner1135953cosigner
costlier1038523costlier
cottier93814173co_ttier
courier93617893co_urier
courtier1059333courtier
couthier13218913couthier
cowier113616163co__wier
cowinner1334753cowinner
cozier173315143co__zier
crucifier1644313crucifier
cuddlier1234013cuddlier
defier105118653__defier
deifier113013123_deifier
dicier94416233__dicier
differ133910843__differ
dodgier10388243dod_gier
edified12339713_edified
edifiers12336673_edifiers
edifies113012283_edifies
fortifier1546253fortifier
gasifier1236273gasifier
glorifier1344233glorifier
godlier938893god_lier
goofier11339313go_ofier
iodizer17408663iodi_zer
mollifier1445163mollifier
mortifier1446923mortifier
nidified1346763nidified
nidifies1238233nidifies
noisier759453no_isier
notified1238363notified
notifiers1245023notifiers
notifies11310423notifies
oilier64417233_o_ilier
ossifier111196273ossifier
pacifier1557503pacifier
podgier11338723pod_gier
purifier1338573purifier
ratifier1139673ratifier
recodified1765533recodified
recodifies16106323recodifies
reifier103414523_reifier
roilier7311523ro_ilier
rotifer1036993rotif_er
scarifier1446653scarifier
scorified1546193scorified
scorifiers1543603scorifiers
scorifies1448023scorifies
typifier1643403typifier
uglifier1244503uglifier
uncodified1743393uncodified
unifier102211863_unifier
verifier14159203verifier
vilifier1456693vilifier
vivifier1745173vivifier

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.440406115.9
2DLD Change Limit1461621247.31019994.8
3Display Results1241240.0631968.3
 (SQL Overall)1786911247.81322871.0
 
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.