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 “codifiers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
codifiers155534(None) 
codifier1447161codifier_
codifies1439641codifie_s
modifiers1584481modifiers
acidifiers16113222acidifiers
codified1537402codifie_d
conifers133611702conif_ers
edifiers12336672_edifiers
modifier1446702modifier_
modifies1439162modifie_s
notifiers1245022notifiers
scorifiers1543602scorifiers
acetifiers1543403acetifiers
acidifier15124383acidifier_
acidifies15126453acidifie_s
basifiers1445203basifiers
certifiers1545143certifiers
citifies13310683citifie_s
clarifiers1544013clarifiers
coalifies1439113coalifie_s
codders114114453cod__ders
coddlers12359173cod_dlers
coders95426983cod___ers
codgers115113933cod__gers
codices12512583codi_ce_s
codicils1346043codici_ls
codrivers1544863codrivers
coffers154112693co__ffers
coiffes1546803co_iffe_s
coiffeurs1741963co_iffeurs
coilers93619903co_i_lers
coiners93620753co_i_ners
coinfers13349503co_infers
cointers103616413co_inters
colliers103613583co_lliers
comfier1439163co_mfier_
comities12317793comitie_s
compliers1538293compliers
confers124120093co_nf_ers
confiders1537483confiders
confiners1439953confiners
conifer123212643conif_er_
copiers114215963co__piers
cornifies1439003cornifie_s
cosigners1245133cosigners
cottiers10399153co_ttiers
couriers103213173co_uriers
courtiers1146693courtiers
cowinners1444133cowinners
crucifiers1743073crucifiers
defiers113913993__defiers
deifiers12348993_deifiers
differs14339973__differs
edifier11309263_edifier_
edifies113012283_edifie_s
fortifiers1644533fortifiers
gasifiers1344523gasifiers
glorifiers1442593glorifiers
iodizers18316123iodi_zers
modified1537273modifie_d
mollifiers1543993mollifiers
mortifiers1544393mortifiers
nidifies1238233nidifie_s
notifier1137423notifier_
notifies11310423notifie_s
ossifiers1274883ossifiers
pacifiers1645463pacifiers
purifiers1435873purifiers
ratifiers1236453ratifiers
recodifies16106323recodifie_s
reifiers11309843_reifiers
rotifers1136043rotif_ers
scarifiers1544103scarifiers
scorifier1445413scorifier_
scorifies1448023scorifie_s
typifiers1742303typifiers
uglifiers1343093uglifiers
unifiers11237173_unifiers
verifiers15166063verifiers
vilifiers1544563vilifiers
vivifiers1843673vivifiers

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 Filter1786911486410.453394461.4
2DLD Change Limit148641816.92321470.6
3Display Results81810.0461760.9
 (SQL Overall)178691817.42224075.9
 
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.