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 “upstarted” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
upstarted124421(None) 
upstared11156571upstar_ed
outstarted1155072outstarted
restarted10410052restarted
started84217322__started
unstarred1036362unstarred
unstated91615812unsta_ted
updarted1244312up_darted
upsoared11154352upsoar_ed
upstaged12135242upsta_ged
upstare9158682upstar_e_
upstares10178582upstar_es
upstart9159752upstart__
upstarts10165272upstart_s
upstate91610492upsta_te_
upstater10156662upsta_ter
upstates10189642upsta_tes
upstirred1241822upstirred
castrated1239513castrated
costarred1244703costarred
disparted1338853disparted
distasted1137963distasted
distorted1139373distorted
estated83715573_esta_ted
gestated102910573gesta_ted
instarred1043963instarred
instated91613343insta_ted
lustrated1037963lustrated
misparted1437263misparted
misstarted1344873misstarted
outsmarted1344323outsmarted
outstared10188423outstar_ed
outstated10169813outsta_ted
parted94228683_p__arted
restated93120183resta_ted
scarted104816123__scarted
smarted105012613__smarted
stared75429873__star_ed
starred85013453__starred
starter73817883__starter
startled9208563__startled
starved114911573__starved
stated75427833__sta_ted
tarted74923373___tarted
uncarted11312053u_ncarted
uncharted1538083uncharted
unparted11310823u_nparted
unsalted9510923uns_alted
unsated83419933uns_a_ted
unscarred1235673unscarred
unseared91113943unsear_ed
unseated91317683unsea_ted
unshared121510703unshar_ed
unshirted13105953unshirted
unsnarled1035743unsnarled
unsorted9312513uns_orted
unstacked1636433unstacked
unstained1038683unstained
unstalked1435523unstalked
unstamped1454603unstamped
unstate71916213unsta_te_
unstates81314993unsta_tes
unstayed12168393unsta_yed
unstinted1038563unstinted
untasted92011573u_ntasted
updated11369423up_da_ted
uphoarded1662273uphoarded
uprated103213323up_ra_ted
upreared1137073uprear_ed
upscaled13144873upsca_led
upshifted1882203upshifted
upstage10167443upsta_ge_
upstager11164633upsta_ger
upstages11147373upsta_ges
upstand1045343upsta__nd
upstaring1235963upstaring
upstarting1343883upstarting
upstaters11174803upsta_ters
upstepped1341943upstepped
upsurged12124043ups_urged
uptalked1533053up_talked
uptilted1174683up_tilted
upturned11214013up_turned
upwafted1742193up_wafted

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641846.62322443.2
3Display Results84840.0332545.5
 (SQL Overall)178691846.81226231.8
 
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.