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

149 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
updarted124431(None) 
updated11369421upda_ted
darted84620922__darted
parted94228682_p_arted
uncarted11312052uncarted
undated93118462unda_ted
unparted11310822unparted
updart9310742updart__
updarts1034202updart_s
update93810292upda_te_
updater10347252upda_ter
updates10329792upda_tes
updried11226472upd_ried
uprated103213322upra_ted
upstarted1244212upstarted
upwafted1742192upwafted
adapted1135843_adapted
biparted1335133biparted
bogarted1235053bogarted
carted98631443__carted
charted135116853_charted
dared75935013__dar_ed
darked123919633__darked
darned85018483__darned
darter75320363__darter
dartled9409853__dartled
dated75530993__da_ted
dauted84114933__dauted
dawted11489683__dawted
departed1238823departed
farted105121783__farted
hearted113314023_hearted
hydrated16216953hydrated
imparted13248063imparted
iodated9310023ioda_ted
marted94425213__marted
nidated939863nida_ted
operated11512223operated
opiated1039483opia_ted
outdared102711513outdar_ed
outdated1012513193outda_ted
panted95024823_p_anted
pared86946763_p_ar_ed
parged104922043_p_arged
parked134425143_p_arked
parled94626293_p_arled
parred95024073_p_arred
parsed96323893_p_arsed
partied103516553_p_artied
pasted94426903_p_asted
pated85237843_p_a_ted
patted94724683_p_atted
pearled10411553_pearled
pearter9412743_pearter
pirated102515613_pirated
plaited103713893_plaited
planted103516123_planted
plated95225773_pla_ted
platted103614263_platted
ported94223243_p_orted
prated94924923_pra_ted
pupated12319353pupa_ted
quadrated2055913quadrated
redacted12410243redacted
redated93120923reda_ted
scarted104816123_scarted
sedated93714353seda_ted
smarted105012613_smarted
spared95427493sp_ar_ed
sparged113512763sp_arged
sparked143513143sp_arked
sparred104512863sp_arred
spatted104014143sp_atted
speared104314423spear_ed
spirted103913073sp_irted
splatted11356743splatted
sported104015433sp_orted
spurted103111973sp_urted
started84217323_started
supported1444683supported
tarted74923373__tarted
thwarted1533363thwarted
umlauted1132823umlauted
unacted10312733u_nacted
unadapted1344653unadapted
unarmed101811923u_narmed
unbarbed13217753unbarbed
unbarred11238703unbarred
unbasted112510073unbasted
unbated103317733unba_ted
uncarded12310133uncarded
uncarved1438163uncarved
uncharted1538083uncharted
uncrated11416313uncrated
undamped1445333undamped
undaunted1145453undaunted
undented102313953undented
underfed13311713underfed
undotted1048523undotted
undraped1239393undraped
undried92314613und_ried
unearned9310063unearned
unearthed1345573unearthed
ungarbed12197063ungarbed
ungated92717213unga_ted
unharmed1438093unharmed
unhatted1238183unhatted
unmarked15248813unmarked
unmarred11258403unmarred
unmated103317023unma_ted
unmatted1138293unmatted
unplaited1236883unplaited
unplanted1236853unplanted
unrated82621553unra_ted
unsalted9510923unsalted
unsated83419933unsa_ted
unsorted9312513unsorted
untasted92011573untasted
unvaried1239683unvaried
unwanted12249603unwanted
unwarmed1437303unwarmed
unwarned1238453unwarned
unwarped1436873unwarped
unwasted12259783unwasted
upcurled1393783upcurled
upcurved16142993upcurved
updarting1334333updarting
updaters11255183upda_ters
updived1434093upd_ived
updries10209083upd_ries
upgazed2033423upga_zed
upgirded1342333upgirded
upgraded13215683upgraded
uphoarded1662273uphoarded
uplifted1454423uplifted
upmarket1644663upmarket
upraised11167413upraised
uprate83916543upra_te_
uprates93814863upra_tes
upreared1137073uprear_ed
uprooted1186393uprooted
upsoared11154353upsoar_ed
upstared11156573upstar_ed
upsurged12124043upsurged
uptalked1533053uptalked
uptilted1174683uptilted
upturned11214013upturned
upward12147163upwar__d
warted104223233__warted

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621496.48622535.0
3Display Results1491490.0602483.3
 (SQL Overall)1786911496.98225593.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.