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

102 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
preorders123540(None) 
preorder1136461preorder_
reorders9198831_reorders
preluders1234422preluders
preordered1443122preordered
presiders1248212presiders
prodders1237462pr_odders
recorders12187952_recorders
reorder8239482_reorder_
accorders14144123accorders
armorers10288973armor_ers
borders104317533__borders
breeders11368893bre_eders
broiders114211193br_oiders
brooders112610243br_ooders
corders104520883__corders
crowders14398813cr_owders
disorders1146963disorders
emborders1444573emborders
herders113914123_he_rders
misorders1245883misorders
orders74315993___orders
pearlers1039033p_earlers
peoplers1237163p_eoplers
performers17164103performers
pervaders1544433pervaders
piercers12316723pie_rcers
pleaders113210183ple_aders
plodders1235523p_lodders
polders103617373p__olders
ponders103618843p__onders
porkers134314933p__orkers
porters93722703p__orters
powders134111553p__owders
preachers16339573preachers
prealters1147773prealters
preavers13910263pre_avers
precedes13310713precede_s
precodes13711573precode_s
precookers1843063precookers
predries112714383predrie_s
preeners102712813pre_eners
prefacers1636293prefacers
prefades1439533prefade_s
preferrers1542983preferrers
prefers123713333pre__fers
preggers12236833pre_ggers
prehardens1673443prehardens
prejudgers2142193prejudgers
preluder1135733preluder_
preludes1137833prelude_s
premiers122911653pre_miers
premodern1444423premodern
preordain12124493preordain
preordains13124523preordains
preordering15124303preordering
preparers13197673preparers
prepregs13144763prepr_egs
prepress12137983prepr_ess
presagers1236943presagers
preservers15115693preservers
presider11410423presider_
presides11414913preside_s
pressers103215023pre_ssers
presters103419003pre_sters
presumers1336373presumers
pretenders1345243pretenders
preyers124412363pre__yers
prioress1035393prior_ess
priories10312453priorie_s
probers113514583pr_o_bers
prodder1147953pr_odder_
proffers16126593pr_offers
proggers12258163pr_oggers
proofers13118363pr_oofers
propers113619033pr_o_pers
prosers94219643pr_o_sers
prospers123012263pr_ospers
prouder10310383pr_ouder_
provers123817793pr_o_vers
providers1535593providers
prowlers13328933pr_owlers
readers83823773_re_aders
rearers74323563_rear_ers
recorder11249633_recorder_
redders93615343_re_dders
reformers14246403_reformers
reloaders1036423_reloaders
renders83821673_re_nders
reoffers1434693_reoffers
reordered1145383_reordered
reporters1139173_reporters
residers93311883_residers
resolders10258013_resolders
resorters939693_resorters
retarders10227573_retarders
retorters938773_retorters
rewarders13226453_rewarders
spreaders1236503spre_aders
suborders1245503suborders
superorders1445623superorders
treaders93311843tre_aders

Search took 10 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.483369960.7
2DLD Change Limit1486411028.73317020.6
3Display Results1021020.0502040.0
 (SQL Overall)1786911029.26619284.6
 
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.