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

107 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
preluders123442(None) 
preluder1135731preluder_
preludes1137831prelude_s
deluders10156432_deluders
eluders8409902__eluders
precludes1445052preclude_s
prejudgers2142192prejudgers
prelude1038012prelude__
preluded1236472prelude_d
preorders1235402preorders
presiders1248212presiders
presumers1336372presumers
breeders11368893bre_eders
colluders12285613colluders
deluder9168333_deluder_
deludes91810643_delude_s
denuders10165873_denuders
elders74817303__el_ders
eluder73712213__eluder_
eludes75417683__elude_s
excluders1942713excluders
fielders12156773fiel_ders
gelders93812573_gel_ders
kreuzers2132063kre_uzers
melders103213913_mel_ders
peelers93615593peel__ers
pelters93720313p_el_ters
perfumers1683713perfumers
perjurers18224463perjurers
persuaders1343353persuaders
perusers10328803p_erusers
pervaders1544433pervaders
pleaders113210183ple_aders
plunders11329833p__lunders
polders103617373p_ol_ders
polluters1135033polluters
preachers16339573preachers
prealters1147773prealters
preaudits1265023preaudits
preavers13910263pre_avers
prebudgets1641713prebudgets
precedes13310713precede_s
preclude1344903preclude__
precluded1544223preclude_d
precodes13711573precode_s
precures12312903precure_s
preeners102712813pre_eners
prefacers1636293prefacers
prefades1439533prefade_s
prefers123713333pre__fers
preggers12236833pre_ggers
preguides1344863preguide_s
prejudger2042553prejudger_
prejudges2043133prejudges
prelates10418573prelate_s
prelives13310383prelive_s
preludial1244873preludial
preluding1337053preluding
prelusory1442873prelusory
premiers122911653pre_miers
premodern1444423premodern
prenumbers1642713prenumbers
preorder1136463preorder_
preparers13197673preparers
prepubes1436053prepube_s
prepuces1438583prepuce_s
prequels1934833prequ_els
presagers1236943presagers
presider11410423presider_
presides11414913preside_s
pressers103215023pre_ssers
presters103419003pre_sters
presumer1247583presumer_
presumes1239843presume_s
pretenders1345243pretenders
prevues1239263prevu_e_s
preyers124412363pre__yers
procurers1345033procurers
prodders1237463pr_odders
producers1454883producers
prouder10310383pr_ouder_
providers1535593providers
prudery1335243pr__udery
prudes94215443pr__ude_s
pruners93710723pr__uners
readers83823773_re_aders
rebukers14435683_rebukers
redders93615343_re_dders
reducers1147263_reducers
refunders1334973_refunders
refusers11499273_refusers
refuters11449613_refuters
relaters83218153_relaters
relaunders1153103_relaunders
relaxers15298263_relaxers
reliers75519213_rel_iers
reloaders1036423_reloaders
relumes9612513_relume_s
renders83821673_re_nders
reorders9198833_reorders
residers93311883_residers
resumers1038083_resumers
spreaders1236503spre_aders
treaders93311843tre_aders
welders113313413_wel_ders
wielders12196613wiel_ders
yielders12164743yiel_ders

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411077.70319296.5
3Display Results1071070.0303566.7
 (SQL Overall)1786911078.13921954.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.