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

144 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
uncreate1031135(None) 
increate10312201increate
uncrate9415951uncr_ate
uncreated12312301uncreated
uncreates11310431uncreates
cocreate122611812cocreate
create85126372__create
increase1066452increase
nucleate1048672nucleate
ocreate93711742_ocreate
recreate10313602recreate
ulcerate1039732ulcerate
uncinate10312392uncinate
uncrated11416312uncr_ated
uncrates10314552uncr_ates
uncreative1547532uncreative
underate9918602underate
unornate848012unornate
untreated10312902untreated
unwreathe1564422unwreathe
accrete1137843accre_te
acerate92818913_acerate
acreage1037833_acreage
aureate72515283_aureate
cerate84829463__cerate
cocreated142710093cocreated
cocreates132611883cocreates
concrete12411083concre_te
crate76537403__cr_ate
crease85519573__crease
created104323443__created
creates95225173__creates
cremate113816183__cremate
crenate93317113__crenate
cuneate9311723cun__eate
decrease1136563decrease
enervate1148453enervate
entreat7315263entreat_
entreated10310973entreated
entreats839773entreats
entreaty1146173entreaty
enucleate1145813enucleate
enwreathe1552863enwreathe
excrete1667163excre_te
inbreathe1443613inbreathe
incarnate1157223incarnate
inchoate1347673inchoate
increased1245533increased
increaser1154573increaser
increases1157383increases
incubate1238663incubate
incudate1138873incudate
incurvate1446053incurvate
ingrate8715113ingr_ate
intreat7416303intreat_
intreated10312663intreated
intreats8311543intreats
lacerate102214703lacerate
laureate888023laureate
macerate122314073macerate
miscreate1348893miscreate
narrate7313493_narrate
nervate1039523_nervate
nuclease1046213nuclease
nucleated1247873nucleated
nucleates1148563nucleates
numerate101610393numerate
ocreae83310273_ocrea_e
picrate112014143picr_ate
procreate1348133procreate
punctate1246473punc_tate
punctuate1343743punctuate
recrate92621643recr_ate
recreated12412533recreated
recreates11313343recreates
runcinate1146473runcinate
secrete9311073secre_te
ulcerated1247743ulcerated
ulcerates1148843ulcerates
umbrette1244943umbrette
unbeaten1038013un_beaten
unbrace111910483unbr_ace
unbrake13239123unbr_ake
uncage93014873unc__age
uncake122813523unc__ake
uncase83817433unc__ase
unchaste1346923unchaste
unciae83215313unc_ia_e
unclean946973unclea_n
uncleaned1237173uncleaned
uncleaner1144763uncleaner
unclear936573unclea_r
uncleared1237543uncleared
unclearer1144623unclearer
uncleft1257493uncleft_
uncoated11314963unc_oated
uncrazy2144063uncr_azy
uncreating13310473uncreating
uncredited1445003uncredited
uncrewed1456763uncrewed
uncute82912133unc__ute
underage101012273underage
undereat9313903undereat_
undereaten1149543undereaten
undereats10310223undereats
underrate10411893underrate
undrape1049333undr_ape
undreamed1336973undreamed
undreamt1156543undreamt
undrest8313013undrest_
undulate9310403undulate
unease63816643un__ease
uneaten7412543un__eaten
unfree9413203unfre__e
unfreeze2043343unfreeze
ungreased1136333ungreased
ungulate939803ungulate
unheated121514553un_heated
unpretty1343263unpretty
unrated82621553un_r_ated
unread73412673un_rea_d
unready11215943un_ready
unreal64414453un_rea_l
unreeve10176763un_reeve
unrelated10310433un_related
unrent63219783un_rent_
unrented92413923un_rented
unrest62918853un_rest_
unrested91914513un_rested
unrests7229463un_rests
unseat64221023un_seat_
unseated91317683un_seated
unseats73012853un_seats
unsheathe15174753unsheathe
unstate71916213un_state
untread857413untrea_d
untreaded1137983untreaded
untreads936223untreads
unweave1336363un_weave
unwreathed1763683unwreathed
unwreathes1673293unwreathes
uprate83916543u_pr_ate
urate55432163u__r_ate
urease64516993u__rease

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.1531167915.0
2DLD Change Limit1461621447.80018738.7
3Display Results1441440.0463130.4
 (SQL Overall)1786911447.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.