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 “preadopting” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

166 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
preadopting174399(None) 
preadapting1743651preadapting
readopting1465511_readopting
readapting1445152_readapting
adopting1237453___adopting
preacting142412533prea__cting
preadaptive1952913preadaptive
preadjusting2352233preadjusting
preadmitting1852763preadmitting
preadopt1348313preadopt___
preadopted1644353preadopt_ed
preadopts1445143preadopt__s
preallotting1551993preallotting
predating13514653pre_d_ating
predicting1649873pre_dicting
preediting1447933preed_iting
preempting1745393pre_empting
presorting1339983pre_sorting
readorning1245723_readorning
adapting1236644___adapting
breading123515464bread___ing
breasting1239584brea__sting
creating113921954crea___ting
crediting1338844cre_d_iting
creosoting1343794creoso_ting
dreading113712804dread___ing
eradiating1248734er_adiating
freebooting1742184freebooting
gradating1237324gr_ad_ating
graduating1345004gr_aduating
headspring17133244_headspring
irradiating1353774irradiating
misadapting1743064misadapting
paradropping1751564paradropping
peacocking2143314p_eacocking
peopling1338354p_e__opling
pleading123011444plead___ing
pleating112916054plea___ting
praelecting1644534praelecting
prating103424454pr_a___ting
preabsorbing1951974preabsorbing
preaccusing1843164preaccusing
preaching172811164prea__ching
preadapt1346864preadapt___
preadapted1643734preadapt_ed
preadapts1444004preadapt__s
prealtering1446174prealtering
preapplying1842194preapplying
prearming14139224prea__rming
preassuring1443824preassuring
preattuning1443044preattuning
preaverring1743244preaverring
preboiling1546404pre_boiling
prebooking1944074pre_booking
precasting15169834pre_casting
precenting151012154pre_centing
prechoosing1943514prechoosing
precoding15109734pre_co_ding
precomputing2153274precomputing
precooking1945044pre_cooking
precooling1545964pre_cooling
precutting1546424pre_cutting
prededucting1952554prededucting
predestine1349324pre_destine
predicating1749654predicating
predrying1645344pre_d_rying
preelecting1646474preelecting
preenacting16125374preenacting
preerecting1646144preerecting
preexciting2343754preexciting
preexempting2661374preexempting
preexisting2144224preexisting
preexposing2352614preexposing
prefading16149034prefad___ing
preforming1846234pre_forming
preheating16310724pre_heating
preimposing1842904preimposing
preinviting1744364preinviting
prelecting15310164pre_lecting
prelimiting1645384prelimiting
preloading1446584pre_loading
prelocating1647414prelocating
premarketing2152564premarketing
premolding1644674pre_molding
preopening1546244pre__opening
preoption1348084pre__option
preoptions1447644pre__options
prepasting15168884pre_pasting
preplanting1645934preplanting
prepping12309764pre___pping
preprinting1647414preprinting
prescoring1547434presco_ring
presenting131013024pre_senting
presetting131010834pre_setting
preshaping1845424preshap_ing
preshipping1852894preshipping
preshowing1944474presho_wing
presifting1638084pre_sifting
presoaking1736254pre_soaking
presolving1644364pre_solving
prestoring13310304presto_ring
pretaping1439134pre_tap_ing
pretasting13239284pre_tasting
pretesting131810684pre_testing
pretexting20206974pre_texting
pretreating1448894pretreating
pretyping1764944pre_typ_ing
preuniting1347304pre_uniting
preventing161210264pre_venting
previsiting1745544previsiting
preworking2044234pre_working
prewrapping1842394prewrapping
prewriting1647244pre_writing
promoting1439924pr_omo_ting
prompting1637204pr__ompting
propping122811674pr___opping
radiating111112134_r_adiating
ragouting1134894_r_agouting
reaccepting1863894_reaccepting
reacting113317894_rea__cting
readdicting1643814_readdicting
readding11411364_read__ding
reading93327214_read___ing
readjusting2042904_readjusting
readmitting1544054_readmitting
readopt10410844_readopt___
readopted1344924_readopt_ed
readopts1146494_readopt__s
readying13410224_read__ying
reallotting1243674_reallotting
reanointing1244994_reanointing
reaping103621214_rea__p_ing
rearousing1156464_rearousing
reasoning10310204_reaso_ning
reassorting1245024_reassorting
reavowing1634864_reavo_wing
rebooting12139024_re_booting
receipting1546754_receipting
recoating121317464_re_coating
recopying1737124_re_copying
redacting13612304_re_dacting
redating102620174_re_d_ating
redipping1555594_re_dipping
redocking17126784_re_docking
redoing93516734_re_do__ing
redonning11127644_re_donning
reediting11310954_reed_iting
refloating14198324_refloating
refronting1437274_refronting
reknotting1564234_reknotting
repeopling1544234_repeopling
replotting1357044_replotting
reporting12513904_re_porting
repotting12511124_re_potting
reradiating1347264_reradiating
rerouting10311874_re_routing
reshooting1436224_reshooting
resorting10614614_re_sorting
respotting1347114_respotting
retorting10613274_re_torting
revolting1339634_re_volting
revoting12312034_re_vo_ting
spreading1339654spread___ing
treading103515334tread___ing
treadling1137504tread__ling
treating92519614trea___ting

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191668.51617475.2
3Display Results1661660.0931784.9
 (SQL Overall)1786911669.03219784.2
 
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.