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

136 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
preorder113646(None) 
preorders1235401preorders
reorder8239481_reorder
preluder1135732preluder
preordered1443122preordered
presider11410422presider
prodder1147952pr_odder
prouder10310382pr_ouder
recorder11249632_recorder
reorders9198832_reorders
accorder1395253accorder
armorer9259913armor_er
border94419973__border
breeder103210043bre_eder
broader103412613br_oader
broider103912973br_oider
brooder103811623br_ooder
corder94322883__corder
crowder13389863cr_owder
disorder1038133disorder
drearier9297923drearier
emborder1345083emborder
herder104516463_he_rder
misorder1147283misorder
order65019363___order
pearler9310373p_earler
pearter9412743p_earter
peopler1138083p_eopler
performer16145133performer
perter84422283p_e_rter
pervader1444863pervader
piercer11337773pie_rcer
pleader103511763ple_ader
plodder1146013p_lodder
polder94019253p__older
ponder94521703p__onder
poorer82613993p_oor_er
porker124917543p__orker
porter84224413p__orter
powder123611903p__owder
preacher153211373preacher
prealter1048863prealter
prearmed1397993prearmed
preaver121011613pre_aver
prebade12310283prebade_
preboarded1663893preboarded
precede1239653precede_
preceded1438293preceded
precedes13310713precedes
preciser123411663preciser
precode12311853precode_
precoded1438863precoded
precodes13711573precodes
precooker1744123precooker
predried12309573predried
predries112714383predries
preener93114833pre_ener
prefacer1537983prefacer
prefade1339013prefade_
prefaded1537823prefaded
prefades1439533prefades
prefer113813203pre__fer
preferrer1443893preferrer
preformed17176203preformed
preharden15104823preharden
prejudger2042553prejudger
preloaded1335923preloaded
prelude1038013prelude_
preluded1236473preluded
preluders1234423preluders
preludes1137833preludes
premade12311443premade_
premerger1444903premerger
premier113515633pre_mier
premodern1444423premodern
premolded1544683premolded
premorse1237553premorse_
preoral9312673preor_al
preordain12124493preordain
preordering15124303preordering
preowned1435213preowned
preparer12169643preparer
preppier1156643preppier
prepreg12165963prepr_eg
presager1138443presager
preserver14127013preserver
preside10715613preside_
presided12410553presided
presiders1248213presiders
presides11414913presides
presorted1239453presorted
presser93717623pre_sser
prester93519623pre_ster
presumer1247583presumer
pretender1246663pretender
prettier1069043prettier
preworked1954653preworked
preyer114413733pre__yer
priories10312453priories
prober104516073pr_o_ber
prodded1257733pr_odded
prodders1237463pr_odders
proffer15126933pr_offer
progger11319373pr_ogger
proofer12149103pr_oofer
proper104319953pr_o_per
proser84223463pr_o_ser
prosier93817493pr_osier
prosper114012193pr_osper
prover113819723pr_o_ver
provider1436703provider
prower114218123pr_o_wer
prowler123310013pr_owler
reader73628293_re_ader
rearer64928913_rear_er
recorded122511073_recorded
recorders12187953_recorders
redder83918143_re_dder
reformer13217953_reformer
reloader937913_reloader
render74024143_re_nder
reoffer1335013_reoffer
reordered1145383_reordered
reporter10411423_reporter
resider84615803_resider
resolder9259233_resolder
resorter8312183_resorter
retarder9229433_retarder
retorter8410733_retorter
rewarder12208233_rewarder
reworded13228103_reworded
spreader1137483spre_ader
suborder1146663suborder
superorder1346373superorder
treader84113833tre_ader
weirder1144923_weirder

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621368.05018156.8
3Display Results1361360.0462956.5
 (SQL Overall)1786911368.49921024.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.