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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

50 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
corduroying185151(None) 
cordoning1338063cord__oning
corduroy1442873corduroy___
corduroyed1751453corduroy_ed
corduroys1542283corduroy__s
cornrowing1643613cor_nrowing
corroding1337943cor__roding
bordering1338834border__ing
borrowing1544564bor__rowing
carbureting1682954carbureting
carburising1653564carburising
carburizing2554124carburizing
carroming1437684car__roming
carrying14148374car__r_ying
coderiving1744994co_deriving
codifying1944954co_d_ifying
codriving1645214co_d_riving
coemploying2152414coemploying
coenduring1444234coendur__ing
colouring1258734colour__ing
concurring1546604concur_ring
condoling13510374cond__oling
condoning1339784cond__oning
conducing1537694condu__cing
conducting1648834condu_cting
conjuring1937914conjur__ing
convoying1835984co__nvoying
copurifying2252754co_purifying
cordelling1446384cord_elling
cording113620824cord____ing
cornering12311894corner__ing
cornifying1944814cor_nifying
corrading1338204cor__rading
corrugating1544264corrugating
corrupting1555584corru_pting
couponing1446294co__uponing
coursing113112024co__ur_sing
courting112514574co__ur_ting
covarying1844134co_var_ying
cowboying2043184co__wboying
currying14196494c___urrying
fordoing1357304ford__o_ing
nondrying1444684nond_r_ying
ordering1039354_order__ing
perduring1336014perdur__ing
portraying1645164por_traying
sorrowing1344874sor__rowing
torturing1036254tortur__ing
wardrobing1742144ward_robing
worrying1534704wor__r_ying

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 Filter1786911488190.406440125.6
2DLD Change Limit148819508.47017570.1
3Display Results50500.0163125.0
 (SQL Overall)178691508.89220095.7
 
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.