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

113 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
uncreating1331047(None) 
uncrating12813181uncr_ating
cocreating15310292cocreating
creating113921952__creating
entreating11811552entreating
increasing1346322increasing
intreating11614012intreating
nucleating1346942nucleating
recreating131214582recreating
ulcerating1346982ulcerating
unceasing1239652unc_easing
uncoating12611922unc_oating
uncreative1547532uncreative
undereating1369552undereating
unresting10311132un_resting
unseating10713202un_seating
untreading1247562untreading
unwreathing1842802unwreathing
accreting1446333accre_ting
cheating144014523__cheating
cleating113518143__cleating
concreting1539873concre_ting
crating103725203__cr_ating
creaking153414123__creaking
creaming133413143__creaming
creasing113314443__creasing
creatin93618133__creatin_
creatine103417413__creatine
creatins103617513__creatins
cremating14312203__cremating
cresting114017043__cresting
decreasing1446513decreasing
encrusting13125293encrusting
encrypting1843053encrypting
enervating1488433enervating
enucleating1444553enucleating
enwreathing1842123enwreathing
escheating1645883escheating
estreating11710363estreating
excreting1946433excre_ting
inbreathing1742803inbreathing
incarnating1445543incarnating
incenting12912063inc_enting
incepting1489293inc_epting
incrusting13126473incrusting
incubating1597133incubating
incurvating1784953incurvating
lacerating1349453lacerating
laureating1146393laureating
macerating1549543macerating
miscreating1648493miscreating
narrating10310353_narrating
numerating1357233numerating
outcheating1744873outcheating
overeating141016533overeating
pancreatin1454233pancreatin_
pancreatins1553843pancreatins
procreating1647693procreating
punctuating1643103punctuating
recrating121318793recr_ating
retreating111414773retreating
screaking16228243_screaking
screaming14217833_screaming
secreting1279823secre_ting
threating131010053_threating
treating92519613__treating
unabating1246753un_abating
unbearing1239353un_bearing
unbelting1237663un_belting
unbracing1437023unbr_acing
unbraking1636933unbr_aking
uncaging1268713unc__aging
uncaking1539463unc__aking
uncaring11312843unc__aring
uncasing11511003unc__asing
uncertain1146203uncertain_
uncloaking1784853uncloaking
uncoatings1384793unc_oatings
uncreate10311353uncreat__e
uncreated12312303uncreat_ed
uncreates11310433uncreat_es
uncrossing1345203uncrossing
uncrowning1644273uncrowning
underacting1547523underacting
underheating1785133underheating
underrating1388253underrating
undraping1337333undr_aping
undrawing1436903undr_awing
undressing1246533undressing
undulating1247143undulating
unfearing1338883un_fearing
unfreeing1345103unfre_eing
unfreezing2343343unfreezing
unleading1138673un_leading
unmeaning1237953un_meaning
unpleasing1344773unpleasing
unreeling1038983un_reeling
unreeving1336213un_reeving
unrooting1098833un_rooting
unscrewing1643203unscre_wing
unsealing10711043un_sealing
unseaming1278113un_seaming
unsetting1088993un_setting
unsheathing1892983unsheathing
unspeaking1744423unspeaking
unstating10711213un_stating
unswearing1444413unswearing
unthreading1644153unthreading
untrusting1186003untrusting
unweaving1636133un_weaving
unweeting1336473un_weeting
uprating11311113u_pr_ating
uprearing1238373u_prearing

Search took 7 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 Filter1786911406030.420425454.8
2DLD Change Limit1406031135.61025062.9
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.07629409.3
 
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.