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

253 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
uncrates1031456(None) 
uncrate9415951uncrate_
uncrated11416311uncrated
uncreates11310431uncreates
crates85736062__crates
ingrates9514172ingrates
picrates122013212picrates
recrates102420372recrates
ulcerates1148852ulcerates
unbraces12229412unbraces
unbrakes14258412unbrakes
uncages103213772unc_ages
uncakes133012742unc_akes
uncarted11312052uncarted
uncases93516552unc_ases
uncoated11314962uncoated
uncreate10311352uncreate_
uncreated12312302uncreated
undrapes1138602undrapes
unrated82621552un_rated
unstates81314992unstates
uprates93814862u_prates
urates65027762u__rates
accretes1238113accretes
aerates74627493_aerates
amirates101114793amirates
animates101316423animates
annates72415423an_nates
berates94126873_berates
borates94823013_borates
bunkmates1743673bunkmates
butyrates1446083butyrates
carates95630613_carates
cartes86239473__cartes
cates75951893__c_ates
cerates95428253_cerates
citrates102315093citrates
cocreates132611883cocreates
concretes13411473concretes
crakes124921813__crakes
cranes84330753__cranes
crapes104727693__crapes
crases85532313__crases
crate76537403__crate_
crated94827773__crated
crater85026643__crater
craters95021893__craters
craves115825393__craves
crazes174720133__crazes
creates95225203__creates
curates95323833_curates
decorates12314743decorates
derates84028893_derates
dictates11311383dictates
disrates91118153disrates
ecartes94212563_ecartes
emirates101214853emirates
enates64026433en__ates
encages103313783enc_ages
encases93116053enc_ases
enchases13310273enchases
enclaves1357703enclaves
enervates1248723enervates
enframes1357453enframes
engraves1237233engraves
enrages83114853en_rages
enunciates1245133enunciates
eucrites1049483eucrites
excretes1787573excretes
execrates1839563execrates
ferrates113013423ferrates
fumarates1445393fumarates
furcates1339883furc_ates
generates10312713generates
grates75429893__grates
gyrates113610263_gyrates
hydrates15229413hydrates
incages103013883inc_ages
incarnates1246713incarnates
incases93615973inc_ases
incites93218483inc_ites
increases1157383increases
increate10312203increate_
incubates1347603incubates
incurvates1545733incurvates
indurates10310693indurates
inflates11512193inflates
ingates82716913in_gates
ingrate8715123ingrate_
inmates92715783in_mates
instates81615833instates
iterates81317823iterates
juniorates1743583juniorates
karates115617473_karates
lacerates112413773lacerates
lactates10311223lactates
librates103412953librates
locates93218813loc_ates
lustrates939463lustrates
macerates132113573macerates
macrames1438953macrames
migrates111112853migrates
misrates101318243misrates
narrates8312763narrates
nates55238333_n__ates
negates83215843_negates
nictates1039593nictates
nidates8311893_nidates
nitrates82516223nitrates
norites74018803_norites
notates72817483_notates
nucleates1148563nucleates
numerates11199573numerates
nutates73214973_nutates
operates10515413operates
orates64328613__orates
outrates82421373outrates
pectates122213953pectates
phorates13413043phorates
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pirates93020333_pirates
prates84633163__prates
prorates10418073prorates
punctate1246473punctate_
punctated1445053punctated
punctuates1443453punctuates
quadrates19117803quadrates
rates55352013___rates
recrate92621663recrate_
recrated112918603recrated
recreates11313363recreates
regrates92618403regrates
runagates1044333runagates
scrapes116217663_scrapes
secretes10410473secretes
serrates82617023serrates
sucrases10310253sucrases
titrates82314663titrates
truncates1145843trunc_ates
tunicates11268743tunicates
ulcerate1039733ulcerate_
ulcerated1247743ulcerated
ululates848433ululates
umbrages1336623umbrages
unabated11310133unabated
unakites1237543unakites
unawares1137053unawares
unbales92914863un_bales
unbated103317733un_bated
unbeaten1038013unbeaten
unbrace111910483unbrace_
unbraced132310433unbraced
unbraids1144963unbraids
unbrake13239123unbrake_
unbraked15289413unbraked
uncage93014873unc_age_
uncaged113314123unc_aged
uncake122813523unc_ake_
uncaked143514353unc_aked
uncaps1039813unc_a_ps
uncarded12310133uncarded
uncarved1438163uncarved
uncase83817433unc_ase_
uncased104216953unc_ased
unchains1338303unchains
unchairs1345503unchairs
uncharges1546213uncharges
uncharted1538083uncharted
unchaste1346923unchaste_
unchaster1445393unchaster
unchastest1543423unchastest
unchokes17227273unchokes
unciae83215313uncia_e_
uncials92510523uncia_ls
uncinate10312393uncinate_
unclamps1443693unclamps
unclasps1244573unclasps
unclawed1457983unclawed
uncles8317163unc__les
uncloses10910943uncloses
unclothes1445143unclothes
uncracked18226803uncracked
uncrating12813183uncrating
uncrazy2144063uncra_zy
uncrewed1456763uncrewed
uncross938193uncr_oss
uncrosses1146153uncrosses
uncrowns1344363uncrowns
uncute82912133unc_ute_
undated93118463un_dated
underages11811083underages
underate9918603underate_
underrates11410563underrates
undrape1049333undrape_
undraped1239393undraped
undraws1136893undra_ws
undulates1048923undulates
unearths1144353unearths
uneases73316263un_eases
uneaten7412543un_eaten
unerased9312773unerased
unframed1478243unframed
unfrees1048643unfr_ees
ungated92717213un_gated
ungraced12239143ungraced
ungraded11209923ungraded
ungulates1048353ungulates
unhats91110623un_hat_s
unheated121514553unheated
unifaces1346393unifaces
unitages938273unitages
unites65024853un__ites
unlaces92513623un_laces
unlades82612833un_lades
unmakes132810793un_makes
unmated103317023un_mated
unornate848013unornate_
unparted11310823unparted
unquotes1745353unquotes
unraked122914013un_raked
unravel1038063un_ravel
unravels1144633un_ravels
unrazed172511453un_razed
unrobes9269733un_robes
unsated83419933un_sated
unseated91317683unseated
unseats73012853unseat_s
unstate71916213unstate_
unstated91615813unstated
unswathes1544213unswathes
untraced112413243untraced
untracks1437523untracks
untreated10312903untreated
untruths1143403untruths
unweaves1436143unweaves
unwraps1255513unwra_ps
unwreathes1673293unwreathes
updates10329793u_pdates
upgrades12216063upgrades
uprate83916543u_prate_
uprated103213323u_prated
upstates10189643upstates
urares64519093u__rares
urases63723563u__rases
urate55432163u__rate_
urinates8314133urinates
vacates12312833vac_ates
venerates12312263venerates
vibrates132210613vibrates
vicarates1487623vicarates
zincates1937743zinc_ates

Search took 8 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.420425454.8
2DLD Change Limit1461622536.50022486.5
3Display Results2532530.0962635.4
 (SQL Overall)1786912537.01625469.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.