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

65 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
accorders1414412(None) 
accorder1395241accorder_
acceders1334792acc_eders
accorded14155352accorde_d
accords1247242accord__s
accouters1344862accouters
camcorders1742222camcorders
corders104520882__corders
recorders12187952recorders
abhorrers1442983abhorrers
aborters1038573a_borters
absconders1542373absconders
absorbers1353983absorbers
acceder1235363acc_eder_
accedes1237723acc_ede_s
accepters15114603accepters
accolades1445433accolade_s
accord1178843accord___
accordant1445353accordant
according1545273according
accordion1443123accordion
accordions1552733accordions
accouter1245363accouter_
accoutres1344383accoutres
accrues1135323acc_rue_s
accusers12285903acc_users
acnodes1037833acno_de_s
adorers84411733a_dor_ers
adorners9196623a_dorners
adsorbers1243263adsorbers
armorers10288973armor_ers
ascenders1235683ascenders
assorters965733assorters
avoiders1254793a_voiders
awarders1245073a_warders
borders104317533__borders
camcorder1642453camcorder_
carders104820353__carders
cavorters1434973cavorters
chowders17387543_chowders
clowders14357473_clowders
codders114114453__codders
coders95426983__co_ders
corder94322883__corder_
corers85231073__cor_ers
corkers134118853__corkers
corners94723313__corners
crowders14398813_crowders
decoders122810413deco_ders
disorders1146963disorders
emborders1444573emborders
encoders1137513enco_ders
misorders1245883misorders
orders74315993___orders
preorders1235403preorders
recorder11249633recorder_
reorders9198833_reorders
scolders11288993_scolders
scorers94115323_scor_ers
scorners10228493_scorners
scowders14276233_scowders
seconders1236953seconders
suborders1245503suborders
succorers13124203succor_ers
vocoders1434243voco_ders

Search took 7 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.406440125.6
2DLD Change Limit148641656.43623095.2
3Display Results65650.0331969.7
 (SQL Overall)178691656.87525991.4
 
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.