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

185 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
updart931074(None) 
updarts1034201updarts
apart74330672ap_art
dart55857872__dart
part65967462_p_art
peart76440752_peart
upcast102710092upcast
updarted1244312updarted
update93810292update
updraft1346032updraft
updry1135482upd_ry
upgirt9117262upgirt
upstart9159752upstart
upwaft1444942upwaft
upward12147162upward
adapt81218553_adapt
apiary113910383apiary
aport75432173ap_ort
apparat11711713apparat
art38679143___art
boart78835933_boart
bogart9617193bogart
cart66570343__cart
cedar84014323cedar_
cedarn9408443cedarn
cedars93312833cedars
cedary12419603cedary
chart105038283_chart
daft85537253__daft
darb76033533__darb
dare55848863__dare
dark95133213__dark
darn56434623__darn
darts67635733__darts
daut56443563__daut
dawt85435943__dawt
depart94720563depart
didact10711203didact
dirt55550383__dirt
drat56247833__drat
dumpcart1543463dumpcart
epact94921533ep_act
fart76860563__fart
hart76865773__hart
heart85440743_heart
impart102715143impart
kart86750803__kart
lidar6312723lidar_
lidars7310783lidars
lyart85121883_lyart
mart66865983__mart
nonart6319193nonart
outdare83113403outdare
oxcart1539523oxcart
pact86648723_p_act
padre86018163_padre
padri85815173_padri
pant66061263_p_ant
par57467023_p_ar_
para65242173_p_ara
pard76441323_p_ard
pare66760843_p_are
park105237493_p_ark
parr65731153_p_arr
pars67560793_p_ars
parts77743373_p_arts
party106630613_p_arty
past65959013_p_ast
pat58089463_p_a_t
pear69745233_pear_
pearl75324463_pearl
pears75138613_pears
peat65967933_pea_t
pedant9319493pedant
pert66759323_p_ert
phat95837863_pha_t
plait75631573_plait
plant75437113_plant
plat66048873_pla_t
port66059633_p_ort
prat65952043_pra_t
quadrat1769273quadrat
quart144027853_quart
radar61316723radar_
radars71314673radars
redact9419043redact
scart76139773_scart
smart75834093_smart
spait75631603sp_ait
spar65433303sp_ar_
spare75135563sp_are
spark114920893sp_ark
spars75431543sp_ars
spat66548523sp_a_t
spear75821063spear_
spears84019473spears
spirt75032953sp_irt
splat76129343spla_t
sport75935983sp_ort
sprat76635973spra_t
spurt77227983sp_urt
start55642313_start
subpart11311123subpart
sudary1038703sudary
support11310523support
swart86234643_swart
tart47566183__tart
thwart12311683thwart
tipcart1148833tipcart
uakari1046863uakari
udder76314283udder_
udders83911293udders
ulnar56013983ulnar_
umlaut838033umlaut
unapt710421593u_napt
unarm7314453u_narm
unary8315993u_nary
unbar71913613unbar_
unbars82113033unbars
uncast84215713uncast
under64624213under_
undraw1037813undraw
unearth1037063unearth
ungirt71112713ungirt
unhat81119263unha_t
unhurt9311253unhurt
unplait948603unplait
unsmart939603unsmart
unwary1239823unwary
upas68322383up_a_s
upbear1096493upbear_
upbears1195423upbears
upbeat10911513upbeat
upbore10247883upbore
upcasts11185643upcasts
upcoast1165543upcoast
upcourt1146103upcourt
upcurl1034963upcurl
updarting1334333updarting
updated11369423updated
updater10347253updater
updaters11255183updaters
updates10329793updates
updive1234903updive
updo76712883upd__o
updos8389513upd_os
updove1234483updove
updrafts1443203updrafts
upgaze1833543upgaze
upgird10103933upgird
uphoard1344573uphoard
upland938863upland
upleapt11116863upleapt
uplift114610653uplift
uplit76020803up_lit
upmarket1644663upmarket
upmost1068193upmost
upper93714263upper_
uppers102912293uppers
uprate83916543uprate
uprear8168793uprear_
uprears9107493uprears
uproar8106933uproar_
uproars986453uproars
uproot8314123uproot
upsent83314063upsent
upset73222593up_set
upshot1138453upshot
upsoar8105683upsoar_
upsoars985413upsoars
upstare9158683upstare
upstarts10165273upstarts
uptake1236963uptake
uptalk1234653uptalk
uptear896783uptear_
uptears9106453uptears
uptilt8410803uptilt
uptore8279453uptore
uptorn8268093uptorn
upturn8286243upturn
upwafts1541943upwafts
upwards13135963upwards
urare56322553u_rare
urari54619963u_rari
wart77866083__wart

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161854.62624365.8
3Display Results1851850.0603083.3
 (SQL Overall)1786911855.06235300.5
 
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.