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

90 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
editress94493(None) 
digress938322_digress
distress9311712_distress
editresses1165072editresses
exitless1534882exitless
redigress1143642redigress
waitress1135222waitress
actress948533_actress
address956103ad_dress
adultress1042943adultress
arbitress1143853arbitress
aviatress1242433aviatress
buttress1035883buttress
debtless1135653debtless
deftness1236303deftness
deities82621923deitie_s
depress10239873_depress
diereses938693_diereses
dieresis956853_dieresis
dimness1038843_dimness
direst75024243_di_rest
dites66339153_dit_e_s
dithers114016153_dithers
ditzes163212423_ditze_s
diureses936453_diureses
diuresis945133_diuresis
dress65319833_d__ress
duress74712063_d_uress
edgeless1034883edgeless
edginess1036053edginess
edibles1048003edible_s
edifiers12336673edifiers
edifies113012283edifie_s
ediles74016983edi_le_s
edited83913673edit_e_d
editions9310403editions
editors839423edit_ors
editrices1245323editrices
editrix1543643editr_ix
editrixes1743813editrixes
edits65819033edit___s
egress73310433e__gress
eldress835003e_ldress
electress1146113electress
elites66027123elit_e_s
emigres1037673emigre_s
emitters10349643emitters
empress1138163e_mpress
endites83717063endit_e_s
entires71517783entire_s
entrees71813773e_ntrees
epitases1038933epitases
epithets1345763epithets
evilness1135043evilness
evites94916473evit_e_s
express1637493e_xpress
fitness10299393_fitness
fortress1136753fortress
goitres8389563goitre_s
heiress1036813hei_ress
hitless103211193_hitless
huntress1144833huntress
jointress1643053jointress
litres65220393_litre_s
mattress1036533mattress
meritless1144593meritless
mistress10310703mistress
mitres83922073_mitre_s
nitres65519333_nitre_s
oratress834553oratress
pedigrees1343373pedigrees
poitrels1035243poitrels
portress1038323portress
prioress1035393prioress
redress82511873red__ress
restress82511773restress
seductress1352253seductress
shitless11249243shitless
slitless8268143slitless
stress66616673__stress
temptress1343133temptress
tigress836093_tigress
titres64718933_titre_s
traitress944403traitress
tress55423163___tress
unstress837373unstress
victress1344523victress
votress1035483_votress
witless103310983_witless
witness103010013_witness

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.420425454.8
2DLD Change Limit146162906.56322270.6
3Display Results90900.0461956.5
 (SQL Overall)178691907.02925422.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.