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

123 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
edifiers1233667(None) 
deifiers12348991deifiers
edifier11309261edifier_
edifies113012281edifie_s
codifiers1555342codifiers
defiers113913992_defiers
deifier113013122deifier_
deifies113317452deifie_s
differs14339972_differs
edifices1454862edifices
edified12339712edifie_d
modifiers1584482modifiers
reifiers11309842reifiers
unifiers11237172unifiers
verifiers15166062verifiers
acetifiers1543403acetifiers
acidifiers16113223acidifiers
aerifies111313393aerifie_s
basifiers1445203basifiers
bediapers1444333bediapers
certifiers1545153certifiers
codifier1447163codifier_
codifies1439643codifie_s
decriers11299733decriers
defers105116943_def_ers
defier105118653_defier_
defies104624053_defie_s
defilers12439473defilers
definers124211193definers
deicers103612733dei_cers
deified123112413deifie_d
deities82621923deitie_s
deniers84515183_deniers
dialers83614303_dialers
diapers104713913_diapers
dibbers124013173_dibbers
dicers94720743_di_cers
dicier94416233_dicier_
dickers144117663_dickers
didies84621833_didie_s
dieters83216433_dieters
differ133910843_differ_
diggers104413393_diggers
dikers114418793_di_kers
dimers94321093_di_mers
dimmers123811563_dimmers
diners75525953_di_ners
dingers94321383_dingers
dinners83915443_dinners
dippers123615183_dippers
dithers114016153_dithers
divers105024963_di_vers
dividers13257213_dividers
diviners12308353_diviners
doffers14359853_doffers
driers74516733_d_riers
drifters12417913drifters
duffers143410093_duffers
eddies83313163ed_die_s
edgers84413923ed__gers
edgier8469733ed_gier_
edibles1048003edible_s
edifice1344933edifi_ce
ediles74016983edi_le_s
editions9310403editions
editors839423edi_tors
editress944933editress
eiders74321363e_i_ders
elixirs1443543elixi_rs
emitters10349643emitters
emptiers1275193emptiers
enviers1036993e_nviers
epimers11109493epi_mers
exilers14419733exi_lers
fifers125414923_fif_ers
gasifiers1344523gasifiers
grifters12389233grifters
heifers1337933heif_ers
knifers14537083knif_ers
lifers95617843_lif_ers
lifters104313783_lifters
liviers104211073_liviers
modifier1446703modifier_
modifies1439163modifie_s
nidifies1238233nidifie_s
niffers13287363_niffers
notifiers1245023notifiers
ossifiers1274883ossifiers
pacifiers1645473pacifiers
pedaliers1245183pedaliers
petrifiers1544673petrifiers
pitiers93812653_pitiers
purifiers1435883purifiers
ratifiers1236453ratifiers
rectifiers1545173rectifiers
redefies12710163redefie_s
reedifies1347323reedifie_s
reifier103414523reifier_
reifies104218283reifie_s
ribiers9319753_ribiers
riflers103512203_riflers
shifters14319863shifters
sifters103714793_sifters
sniffers14257123sniffers
snifters11318613snifters
specifiers1743803specifiers
stiflers11238833stiflers
swifters14277483swifters
terrifiers13144573terrifiers
testifiers13124503testifiers
tidiers8389773_tidiers
triflers113110223triflers
typifiers1742303typifiers
uglifiers1343093uglifiers
unifier102211863unifier_
unifies102714713unifie_s
verifier14159203verifier_
verifies141313483verifie_s
versifiers16154143versifiers
vilifiers1544563vilifiers
vivifiers1843673vivifiers
viziers19336203_viziers
whiffers2064493whiffers

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.423422437.4
2DLD Change Limit1461621238.09318060.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911238.56220870.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.