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

112 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
presoaked163565(None) 
resoaked1337941_resoaked
prebaked1737172pre_baked
prebooked1863912prebooked
precooked1844992precooked
preloaded1335922preloaded
presaged1238802pres_aged
preshaped1745522preshaped
presoak1348452presoak__
presoaks1436602presoak_s
presolved1545272presolved
presorted1239452presorted
preworked1954652preworked
creaked143413233cre__aked
croaked143710533cr__oaked
freaked15399703fre__aked
oversoaked1845823oversoaked
peaked136117403p_e__aked
personated13258293personated
persuaded1344373persuaded
phreaked1834493phre__aked
preaged11612333pre__aged
prebake1539093pre_bake_
prebakes1639013pre_bakes
preboard1338263preboa_rd
preboarded1663893preboarded
preboiled1455783preboiled
precoded1438863preco_ded
precooker1744123precooker
precooled1446363precooled
predated12513273pre_dated
prefaced1638423pre_faced
prefaded1537823pre_faded
preformed17176203preformed
prefranked2042773prefranked
preheated1539813preheated
preload1049813preloa__d
prelocated1597183prelocated
premolded1544683premolded
preowned1435213pre_owned
prepacked20155653prepacked
prepared132210873pre_pared
prepaved16177233pre_paved
preplaced1676483preplaced
presage10312293pres_age_
presager1138443pres_ager
presages11312203pres_ages
presale9416353pres_ale_
presales10315263pres_ales
prescored14409403prescored
presented12311633presented
preserved15107563preserved
preshape1537533preshape_
preshapes1667093preshapes
preshowed1875183preshowed
presided12410553pres_ided
presifted1536873presifted
presliced1435983presliced
presoaking1736253presoaking
presold1059603preso__ld
presolve1347073presolve_
presolves1456533presolves
pressed103317313pres__sed
pressured1237333pressured
prestamped1742963prestamped
prestored125111673prestored
presumed1337973pres_umed
pretaped13339133pre_taped
prisoned1138813priso_ned
provoked1875053provo_ked
reawaked16366623_reawaked
rebooked15226503_rebooked
recoaled113111783_recoaled
recoated113416783_recoated
recocked17248473_recocked
recooked15268243_recooked
recorked15239853_recorked
redocked16206823_redocked
reloaded1059103_reloaded
reloaned939723_reloaned
relocked15217743_relocked
relooked13236653_relooked
resawed113111183_res_awed
rescaled113311303_rescaled
resealed92713963_resealed
reseated93220263_reseated
reshaped1437203_reshaped
reshaved1536873_reshaved
reslated93517523_reslated
resoak10311093_resoak__
resoaks1148973_resoak_s
resodded1136353_resodded
resoled84119283_reso_led
resolved12349343_resolved
resonated10510613_resonated
resorbed1138533_resorbed
resorted9313493_resorted
resowed113712253_reso_wed
respaced1338503_respaced
respaded1238133_respaded
restacked1636483_restacked
restaged103011863_restaged
restated93120183_restated
restocked1655173_restocked
restoked135710533_restoked
revoked154410523_revo_ked
rewaked153811903_re_waked
reworked16247773_reworked
soaked114717593___soaked
troaked12438253tr__oaked
unsoaked1338853_unsoaked
wreaked15369023wre__aked

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.453394461.4
2DLD Change Limit1486411127.71619264.0
3Display Results1121120.0502240.0
 (SQL Overall)1786911128.21921741.2
 
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.