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

176 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
preload104981(None) 
preloads1157511preloads
reload7413891_reload
armload1044292armload
freeload1244732freeload
payload1336402payload
preboard1338262preboard
prelaw1139102prel_aw
preloaded1335922preloaded
premold1247862premold
presoak1348452presoak
presold1059602presold
pretold1049082pretold
reloads8911312_reloads
reloan6415692_reloan
areola6813673areola_
areolae7811733areolae
areolar779223areolar
areolas71013863areolas
armloads1144233armloads
bread85523113bre__ad
broad84817693br__oad
busload1044683busload
carload1039783carload
cartload1145033cartload
caseload1145623caseload
cheloid13310833cheloid
delead84112343_delead
dread74419023dre__ad
erelong835593erelong
freeloads1343903freeloads
keloid11812623_keloid
load56730603___load
meloid9616003_meloid
myeloid13108123myeloid
oceloid1037973oceloid
offload1443203offload
onload7268633_onload
oread64619603ore__ad
overload12119283overload
paella8410913paella_
paellas9411413paellas
payloads1445293payloads
peeled94119713peel_ed
pelon74423213p_elo_n
pelota8612833p_elota
pelotas9410723p_elotas
pelted94617763p_elted
pentad9313763p_entad
percoid12312313percoid
period9314983perio_d
pernod9310453perno_d
planeload1243723planeload
plead85818463p__lead
pleiad947833ple_iad
plod76723273p__lo_d
preaged11612333preaged
preanal9310713preanal
prebade12310283pre_bade
prebend12319443prebend
prebid113512843pre_bid
prebind123810643prebind
preboards1446423preboards
preboil1148953preboil
prebook1557523prebook
preboom1348253preboom
prebound1345893prebound
preclean1245893preclean
preclear1245423preclear
precode12311853precode
precoded1438863precoded
precook1577803precook
precool1139013precool
precoup1336123precoup
predial103815413predial
preed85128123pre__ed
preened103214993preened
prefab1336243pre_fab
prefade1339013pre_fade
preform1439613preform
prefund1335733prefund
preheat12413893preheat
prelacy1437583prelacy
prelate9519693prelate
prelect111013833prelect
prelegal1145053prelegal
prelife1279943prelife
prelim10311423prel_im
prelims1139823prelims
preloading1446583preloading
prelocate13109513prelocate
prelocated1597183prelocated
prelude1038013prelude
preluded1236473preluded
premade12311443pre_made
preman104117453pre_man
premeal11310523premeal
premed114617763pre_med
premolar1246633premolar
premolds1345843premolds
premolt11312073premolt
premoral1249713premoral
prenoon9310043prenoon
preop94715873pre_o_p
preops104911943pre_ops
preoral9312673preoral
prepaid12310133prepaid
prepay13310313pre_pay
preplan1149953preplan
prepped11329903prepped
prerock1536723prerock
presa74319043pre_sa_
presoaked1635653presoaked
presoaks1436603presoaks
presong1039843presong
presort95219543presort
pressed103317313pressed
pretax152310193pre_tax
pretend104011013pretend
pretor8315753preto_r
pretors9316813pretors
prevued1337143prevued
prewar114712583pre_war
prework164210913prework
preworn124711223preworn
prewrap14104973prewrap
preyed125313203pre_yed
prilled104713003prilled
proa66229963pr__oa_
proas75028803pr__oas
prod76129503pr__o_d
prolan8414693prol_an
prolog94212973prolo_g
prologed12189213prologed
prologs103512133prologs
prolong10319633prolong
promoed12310083promoed
proud84615483pr__oud
pureblood1471943pureblood
pyrenoid1446873pyrenoid
read55942533_re__ad
reboard10310763_reboard
reclad9311873_reclad
recoal84117973_recoal
recoat84024273_recoat
record96117433_record
refloat10310833_refloat
reflood1136363_reflood
refold103812113_refold
relaid75518443_relaid
reland75920433_reland
relax124817803_rel_ax
relay84424673_rel_ay
relend76116453_relend
relied74926233_relied
reloaded1059103_reloaded
reloader937913_reloader
reloaned939723_reloaned
reloans7313133_reloans
relock124713523_relock
relook104813743_relook
remold93412973_remold
replead10399013_replead
reread71715433_reread
resoak10311093_resoak
resod64720053_reso_d
resold73915363_resold
retold73013753_retold
reword106321413_reword
road56332113_r__oad
spread9312533spre__ad
tread64821703tre__ad
unload73010803_unload
upload9257783_upload
vanload1144703vanload
workload1643023workload

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271767.11018850.5
3Display Results1761760.0602933.3
 (SQL Overall)1786911767.57623586.5
 
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.