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

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

86 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
documenters165281(None) 
documenter1553281documenter_
documentary1953062documentary
documented1653202documente_d
documents1446522document__s
cementers1338313__cementers
commenters16139483co_mmenters
decameters15156593decame_ters
decenters122410373dec__enters
decimeters15156683decime_ters
dockmasters2053103dockmasters
document1348663document___
documental1554513document_al
documentaries1863263documentaries
documentarist18163973documentarist
documenting1753123documenting
dosimeters1345113dosime_ters
fomenters1437853fo__menters
tormenters1245823to_rmenters
volumeters1543993volume_ters
augmenters1343514_augmenters
bolometers1447384bolome_ters
cementer1239194__cementer_
centers94420604__c__enters
circumcenters1862654circumcenters
commencers18156374co_mmencers
commenders17137144co_mmenders
commenter151410694co_mmenter_
concenters14410584co_ncenters
consenters12410844co_nsenters
counters103320194co_u__nters
dasymeters1643594dasyme_ters
daunters9329854d_au__nters
decameter14137364decame_ter_
decanters12229224dec__anters
decenter112412164dec__enter_
decentres12238524dec__entres
decimeter14147414decime_ter_
decimetres15135044decime_tres
dekameters17164864dekame_ters
diameters1247604d_iame_ters
dimeters11411094d__ime_ters
dissenters1197724d_issenters
docents102810804doc__ent__s
dockmaster1963074dockmaster_
documentable1982514documentable
documentalist18144894documentalist
documentarian18143034documentarian
documentarians19162644documentarians
documentarily2162644documentarily
documentarists19113124documentarists
domineers1244674do__mineers
doomsters1236174do_om_sters
dopesters1237284do__pesters
dosimeter1245364dosime_ter_
doubters11257394do_u__bters
douzepers2142044do_uze_pers
drumbeaters1651844d_rumbeaters
dumpsters1453744d__umpsters
durometers1356374durome_ters
dynameters1643794dyname_ters
fermenters15116534_fermenters
fomenter1339264fo__menter_
incenters112510304inc__enters
lamenters1137684__lamenters
monometers1449364monome_ters
monuments1397634monument__s
mounters103712504mo_u__nters
octameters1444834_octame_ters
odometers1247134_odome_ters
ohmmeters1643784_ohmme_ters
orienters937614_o_rienters
orometers11310424_orome_ters
oximeters1855144_oxime_ters
picometers1648284picome_ters
pocketers17196494poc_ke_ters
potometers1449064potome_ters
rocketers15186884roc_ke_ters
rotameters1245034rotame_ters
tonometers1248114tonome_ters
tormenter1146704to_rmenter_
tormentors1244174to_rmentors
udometers1245744udo__me_ters
undocumented1851804undocumente_d
voltmeters1554284voltme_ters
volumeter1444004volume_ter_

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 Filter1786911488190.436409841.7
2DLD Change Limit148819868.43617640.9
3Display Results86860.0461869.6
 (SQL Overall)178691868.91820037.1
 
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.