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

125 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
predrying164534(None) 
redrying13209021_redrying
prearming14139222prearming
prebuying1734302prebuying
predating13514652predating
prepaying1747972prepaying
prettying1536042prettying
preying133114552pre__ying
refrying15278902_refrying
retrying122410452_retrying
berrying14137373_berrying
crediting1338843crediting
decrying15237413_decrying
dredging12236423dred_ging
drying113411603___drying
eddying1335293__eddying
ferrying15146243_ferrying
frenzying2542413frenzying
greying124110893gre__ying
herrying15147023_herrying
nondrying1444683nondrying
ordering1039353order_ing
overdrying1846543overdrying
pandying15217663pand_ying
panfrying1842993panfrying
parodying1655423parod_ying
parrying14168133p_arrying
pearling11912013p_earling
pedaling122412133p_edaling
peddling13217973p_eddling
peering103520353p_eer_ing
perduring1336013perduring
perking143716463p_e_rking
perming123416093p_e_rming
phrensying1942113phrensying
piercing1346663pie_rcing
pledging13276363pled_ging
praying133717323pr__aying
preaching172811163preaching
preacting142412533preacting
prebaking1838063prebaking
preceding15129363preceding
precising14413273precising
precoding15109733precoding
precuring1439423precuring
predefine1546173predefine
predicting1649873predicting
predried12309573predr_ied
predries112714383predr_ies
predrill1145933predr_ill
predrilling1543673predrilling
predry1237873predry___
preediting1447933preediting
preeing103817673pre__eing
preening113115843pre_ening
prefacing17118743prefacing
prefading16149033prefading
preferring1645623preferring
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
preforming1846233preforming
prehiring1548383prehiring
preluding1337053preluding
premising14412413premising
premixing2157803premixing
preparing14311643preparing
prepaving1787233prepaving
prepping12309763pre_pping
prepricing1746733prepricing
preprint12314183prepr_int
presaging1339393presaging
preserving1637363preserving
presiding13510903presiding
presorting1339983presorting
pressing112516443pre_ssing
presuming1437663presuming
pretaping1439133pretaping
pretrain10310923pretrain_
pretrains11410143pretrains
pretyping1764943pretyping
prevising15510873prevising
prevuing1457253pre_vuing
prewarming18145173prewarming
prewarning16135193prewarning
prewiring1547893prewiring
preworking2044233preworking
prewriting1647243prewriting
priding113317543prid__ing
prodding13189343prod_ding
producing1556143producing
prying124114803p___rying
querying2135243que_rying
readying13410223_readying
rearing83128783_rear_ing
rearming111413613_rearming
reburying1535193_reburying
rebuying1436743_rebuying
redating102620173_redating
redding103218513_red_ding
reddling112911813_reddling
redefying1736093_redefying
redenying1437783_redenying
reding83825563_red__ing
redoing93516733_red_oing
redrawing1437213_redrawing
redriving1437603_redriving
reducing12310203_reducing
redwing122811983_red_wing
redyeing1336173_redyeing
reflying15268173_reflying
reifying1539383_reifying
rekeying1637563_rekeying
relaying122515153_relaying
relying112914613_re_lying
repaying142712393_repaying
replying14269403_replying
resaying122512453_resaying
retying113213833_re_tying
serrying12167693_serrying
treddling1234423treddling
updrying1534013_updrying
uprearing1238373uprear_ing
wearying1546703_wearying
wherrying1952993wherrying

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.423422437.4
2DLD Change Limit1486411257.78019105.5
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.24921662.1
 
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.