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

106 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
preloaded133592(None) 
reloaded1059101_reloaded
freeloaded1542602freeloaded
preboarded1663892preboarded
precoded1438862preco_ded
prefaded1537822pre_faded
preload1049812preloa__d
preloads1157512preload_s
prelocated1597182prelocated
preluded1236472prel_uded
premolded1544682premolded
presoaked1635652presoaked
reloader937912_reloader
reloaned939722_reloaned
areolated1089713areolated
breaded115014063bre__aded
deleaded1148333_deleaded
dreaded103612023dre__aded
freeloader1452613freeloader
loaded84616873___loaded
offloaded1741843offloaded
onloaded1044743_onloaded
overloaded1566593overloaded
persuaded1344373persuaded
pervaded1535373p_ervaded
pleaded113511263p__leaded
plodded1265563p__lodded
preaged11612333pre__aged
prebade12310283pre_bade_
prebaked1737173pre_baked
preboard1338263preboa_rd
preboiled1455783preboiled
prebooked1863913prebooked
preceded1438293pre_ceded
precleaned1543803precleaned
precleared1544113precleared
precluded1544223precluded
precode12311853preco_de_
precodes13711573preco_des
precooked1844993precooked
precooled1446363precooled
predated12513273pre_dated
prefaced1638423pre_faced
prefade1339013pre_fade_
prefades1439533pre_fades
preformed17176203preformed
prefunded1644693prefunded
preguided1443923preguided
preheated1539813preheated
prelate9519693prel_ate_
prelates10418573prel_ates
prelected1439133prelected
preloading1446583preloading
prelocate13109513prelocate_
prelocates1468353prelocates
prelude1038013prel_ude_
preluder1135733prel_uder
preludes1137833prel_udes
premade12311443pre_made_
preorder1136463pre_order
preowned1435213pre_owned
prepared132210873pre_pared
prepaved16177233pre_paved
preplaced1676483preplaced
presaged1238803pre_saged
preshaped1745523preshaped
presided12410553pre_sided
presolved1545273presolved
presorted1239453presorted
pretaped13339133pre_taped
pretended1337193pretended
preworked1954653preworked
prodded1257733pr__odded
prologed12189213prolo_ged
prologued1344663prologued
prolonged13285413prolonged
reboarded1365613_reboarded
recoaled113111783_recoaled
recoated113416783_recoated
recoded113115033_reco_ded
recorded122511063_recorded
refloated1347013_refloated
reflooded1443553_reflooded
refolded1337063_refolded
regraded113410763_regraded
relaced103517213_rel_aced
relanded102410463_relanded
related83327573_rel_ated
relaxed153312533_rel_axed
relayed113212753_rel_ayed
released9310243_released
reload7413893_reloa__d
reloaders1036423_reloaders
reloads8911313_reload_s
relocated12710813_relocated
relocked15217743_relocked
relooked13236653_relooked
remolded1237403_remolded
repleaded1336293_repleaded
resoaked1337943_resoaked
resodded1136353_resodded
respaded1238133_respaded
reworded13228103_reworded
treaded95014283tre__aded
unloaded1049533_unloaded
uploaded1234533_uploaded

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 Limit1486411067.89318832.0
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.34521412.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.