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

298 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
uncrate941595(None) 
uncrated11416311uncrated
uncrates10314561uncrates
uncreate10311351uncreate
crate76537402__crate
increate10312202increate
ingrate8715122ingrate
picrate112014142picrate
punctate1246472punctate
recrate92621662recrate
ulcerate1039732ulcerate
unbrace111910492unbrace
unbrake13239122unbrake
uncage93014872unc_age
uncake122813522unc_ake
uncarted11312052uncarted
uncase83817432unc_ase
unchaste1346922unchaste
unciae83215312uncia_e
uncinate10312392uncinate
uncoated11314962uncoated
uncrazy2144062uncrazy
uncreated12312302uncreated
uncreates11310432uncreates
uncute82912132unc_ute
underate9918602underate
undrape1049332undrape
unornate848012unornate
unrated82621552un_rated
unstate71916212unstate
uprate83916542u_prate
urate55432162u__rate
accrete1137843accrete
accurate12410663accurate
acerate92818913acerate
acuate8315633_acuate
aduncate1145573adunc_ate
aerate64830553_aerate
amirate91115953amirate
animate91617213animate
ansate64517863an_sate
arcuate9311963arcuate
aurate64426473_aurate
baccate131011263baccate
berate84729023_berate
borate85026153_borate
bunkmate1643963bunkmate
butyrate1346203butyrate
carate84734003_carate
carte75940423__carte
cate66254603__c_ate
cerate84829463_cerate
cirrate92413493cirrate
citrate92216803citrate
cocreate122611813cocreate
concrete12411083concrete
crake114823523__crake
crane75331603__crane
crape96128443__crape
crated94827773__crated
crater85026643__crater
crates85736063__crates
crave105626313__crave
craze165221463__craze
create85126383__create
cultrate10310873cultrate
cuneate9311723cun_eate
curate85226243_curate
decorate11315193decorate
derate74531233_derate
dictate10311663dictate
disrate81418523disrate
ecarte84313503_ecarte
emirate91015833emirate
enate54428153en__ate
encage93713503enc_age
encase83714363enc_ase
enchase1239463enchase
enclave1257533enclave
enervate1148463enervate
enframe1247363enframe
engrave1137133engrave
enrage72715073en_rage
enunciate1145743enunciate
eucrite939903eucrite
excrete1667163excrete
execrate1739653execrate
ferrate103014043ferrate
fumarate1345683fumarate
furcate12310453furc_ate
generate9312903generate
grate64932883__grate
gyrate104912523_gyrate
hydrate14239813hydrate
incage93513623inc_age
incarnate1157223incarnate
incase83615283inc_ase
inchoate1347673inchoate
incite83618733inc_ite
increase1066453increase
incubate1238663incubate
incudate1138873incudate
incurvate1446063incurvate
indurate9311873indurate
inflate10312313inflate
ingate73018243in_gate
ingrates9514173ingrates
inmate82917363in_mate
innate63917313in_nate
instate71616483instate
irate55627983__irate
iterate71119113iterate
juniorate1644013juniorate
karate105320923_karate
lacerate102214713lacerate
lactate9312703lactate
librate93214233librate
locate83919843loc_ate
lunate6316043lun__ate
lunulate838253lunulate
lustrate8310443lustrate
lyrate94112103_lyrate
macerate122314073macerate
macrame1338713macrame
migrate101314173migrate
misrate91319143misrate
narrate7313493narrate
negate72915573_negate
nervate1039533_nervate
nictate9310223nictate
nidate7313783_nidate
nitrate72017013nitrate
norite63221133_norite
notate63217863_notate
nuchae11218513nucha_e
nucleate1048673nucleate
numerate101610393numerate
nutate63017373_nutate
ocreate93711743_ocreate
operate9615733operate
orate55133303__orate
outrate72323183outrate
overate10620963overate
pectate112214693pectate
phorate12413363phorate
picrated132110113picrated
picrates122013213picrates
picrite111911313picrite
pirate82322883_pirate
prate75135983__prate
prorate9418733prorate
punctated1445053punctated
punctuate1343743punctuate
quadrate1888043quadrate
rate45458763___rate
recrated112918603recrated
recrates102420373recrates
recreate10313603recreate
regrate82618663regrate
runagate944293runagate
runcinate1146473runcinate
saccate111311763saccate
scrape105917573_scrape
secrete9311073secrete
serrate73017543serrate
sucrase9310343sucrase
sulcate9314423sulc_ate
titrate72215573titrate
toccate1138773toccate
truncate1046283trunc_ate
tunicate103310043tunicate
ulcerated1247743ulcerated
ulcerates1148853ulcerates
ululate749963ululate
umbrae1038683umbra_e
umbrage1236723umbrage
unabated11310133unabated
unakite1138743unakite
unawake1445343unawake
unaware1038033unaware
unbale83616403un_bale
unbated103317733un_bated
unbeaten1038013unbeaten
unbraced132310433unbraced
unbraces12229413unbraces
unbraid1037183unbraid
unbraked15289413unbraked
unbrakes14258413unbrakes
unbroke13217743unbroke
uncaged113314123unc_aged
uncages103213773unc_ages
uncaked143514353unc_aked
uncakes133012743unc_akes
uncap9312283unc_a_p
uncaps1039813unc_aps
uncarded12310133uncarded
uncarved1438163uncarved
uncased104216953unc_ased
uncases93516553unc_ases
uncast84215713unc_ast
unchain1238943unchain
unchair1236163unchair
uncharge1446313uncharge
uncharted1538083uncharted
unchary1537263unchary
unchaster1445393unchaster
unchoke16248193unchoke
uncia75015163uncia__
uncial83715223uncia_l
uncials92510523uncials
unclad938913uncla_d
unclamp1344993unclamp
unclasp1135963unclasp
unclawed1457983unclawed
uncle7317053unc__le
unclose91111643unclose
unclothe1345703unclothe
uncouth1247173uncouth
uncracked18226803uncracked
uncrating12813183uncrating
uncreative1547533uncreative
uncrewed1456763uncrewed
uncross938193uncross
uncrown1236323uncrown
uncurable13710073uncurable
uncut73219173unc_ut_
undated93118463un_dated
underage101012273underage
underrate10411893underrate
undraped1239393undraped
undrapes1138603undrapes
undraw1037813undra_w
undrawn1145293undrawn
undraws1136893undraws
undulate9310403undulate
unearth1037063unearth
unease63816643un_ease
uneaten7412543un_eaten
unerased9312773unerased
unframed1478243unframed
unfree9413203unfr_ee
unfroze1945413unfroze
ungated92717213un_gated
ungraced12239143ungraced
ungraded11209923ungraded
ungulate939803ungulate
unhat81119263un_hat_
unhats91110623un_hats
unheated121514553unheated
uniface1236953uniface
unitage838993unitage
unite54828383un__ite
unlace82215173un_lace
unlade72714153un_lade
unmade92911063un_made
unmake122811213un_make
unmated103317023un_mated
unparted11310823unparted
unquote1645903unquote
unraked122914013un_raked
unravel1038063un_ravel
unrazed172511453un_razed
unripe82012093un_ripe
unrobe82611673un_robe
unrove92511683un_rove
unsafe9310693un_safe
unsated83419933un_sated
unseat64221023unseat_
unseated91317683unseated
unseats73012853unseats
unstated91615813unstated
unstates81314993unstates
unswathe1444603unswathe
untame82513603un_tame
untraced112413243untraced
untrack1338703untrack
untreated10312903untreated
untrue6310773untr_ue
untruth1045353untruth
unweave1336363unweave
unwhite1336813unwhite
unwrap11126323unwra_p
unwraps1255513unwraps
unwreathe1564423unwreathe
update93810293u_pdate
upgrade11215823upgrade
uprated103213323u_prated
uprates93814863u_prates
upstate91610493upstate
urare56322553u__rare
urase54624693u__rase
urates65027763u__rates
urinate7315363urinate
vacate11314553vac_ate
venerate11312903venerate
vibrate122811523vibrate
vicarate1378603vicarate
zincate1838533zinc_ate

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272987.15618729.3
3Display Results2982980.1102709.1
 (SQL Overall)1786912987.66923300.4
 
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.