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

142 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
updrying153401(None) 
drying113411602__drying
prying124114802_p_rying
redrying13209022redrying
undying1238502und_ying
updarting1334332updarting
updating1236592updating
updiving1534222updiving
applying1634653applying
berrying14137373berrying
bodying1438973bod_ying
buddying16274793buddying
burying133413913_burying
caddying16225063caddying
carrying14148373carrying
crying123612283__crying
currying14196493currying
dairying1336353dairying
decrying15237413decrying
draying123813843__draying
dying105316033__d_ying
eddying1335293_eddying
epoxying2133033epoxying
ferrying15146243ferrying
frying134511403__frying
giddying1533783giddying
glorying1335543glorying
harrying15157643harrying
herrying15147023herrying
hurrying15145533hurrying
jurying18337763_jurying
marrying14157223marrying
muddying16254543muddying
nondrying1444683nondrying
outcrying1576093outcrying
parging113318603_parging
paring94236493_par_ing
parking143423043_parking
parling103823763_parling
parring103222063_parring
parrying14168133parrying
parsing103819553_parsing
parting103527383_parting
partying14168893_partying
paying123722163_p_aying
perking143716463_perking
perming123416093_perming
pitying132910243_pitying
playing133816093_playing
ploying132811573_ploying
plying124312083_p_lying
ponying133312123_ponying
poring94227273_por_ing
porking143515813_porking
porting103021783_porting
praying133717323_praying
predrying1645343predrying
preying133114553_preying
pudding124010803pud_ding
puddling13218033puddling
purging113314183_purging
purling103620293_purling
purring104515823_purring
pursing103715553_pursing
puttying1434953puttying
quarrying2273733quarrying
querying2135243querying
refrying15278903refrying
retrying122410453retrying
scrying1338663_scrying
serrying12167693serrying
sparging122611133sparging
sparing104823873spar_ing
sparking152812543sparking
sparling112714533sparling
sparring113112223sparring
spaying133014623sp_aying
spiring103918183spir_ing
spirting112913633spirting
splaying14219303splaying
sporing104319413spor_ing
sporting112415463sporting
spraying14299883spraying
spring94526013sp_r_ing
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
spying123913253sp__ying
storying12249673storying
supering11317683super_ing
superlying1645383superlying
supplying1774043supplying
tarrying12146723tarrying
tidying1238513tid_ying
trying104214073__trying
umpiring1336093umpir_ing
unarming1138623unarming
undaring10412753undaring
underling111514613underling
underlying15136373underlying
underwing141410883underwing
undoing9312243und_oing
undraping1337333undraping
undrawing1436903undrawing
unerring9311273unerring
unifying1537553unifying
unlaying1258363unlaying
unpaying1456943unpaying
unpitying1544043unpitying
unsaying1288153unsaying
untying1138943u_ntying
unvarying1644503unvarying
upcoming1535173upcoming
upcurling1453493upcurling
upcurving1742563upcurving
updried11226473updr_ied
updries10209083updr_ies
updry1135483updry___
upending12258133upending
upfling1337093up_fling
upgazing2133313upgazing
upgirding1442373upgirding
upgoing1135353up_going
upgrading1444903upgrading
upgrowing1643123upgrowing
uppiling1335853uppiling
upping114013703up__ping
uprating11311113uprating
uprising1138953uprising
upsizing2035413upsizing
upspring1335703upspring
upsurging1343353upsurging
upswing1335593up_swing
upturning1263373upturning
urging83413123u__rging
urping93914053u__rping
usurping1134163usurping
varying1429723_varying
waddying17204723waddying
wearying1546703wearying
worrying1534703worrying
wrying13379623__wrying

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.860207780.2
2DLD Change Limit1461621427.09320606.5
3Display Results1421420.1101290.9
 (SQL Overall)1786911428.06322161.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.