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

116 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
updarting133433(None) 
updating1236591upda_ting
darting94020662__darting
parting103527382_p_arting
undaring10412752undar_ing
upcasting1434822upcasting
updrying1534012upd_rying
uprating11311112upra_ting
upstarting1343882upstarting
upwafting1842062upwafting
adapting1236643_adapting
bogarting1334653bogarting
carting104228283__carting
charting142614193_charting
daring84928683__dar_ing
darking134217343__darking
darling93418363__darling
darning93817333__darning
dartling1039563__dartling
dating85326483__da_ting
dauting93814763__dauting
dawting123610673__dawting
departing1349513departing
farting114120753__farting
hearting12513123_hearting
hydrating1746323hydrating
imparting1437243imparting
iodating1038823ioda_ting
karting123716063__karting
marting103325013__marting
nidating1039783nida_ting
operating12313723operating
opiating11410093opia_ting
outdaring1179723outdar_ing
outdating11810863outda_ting
panting104025423_p_anting
parging113318603_p_arging
paring94236493_p_ar_ing
parking143423043_p_arking
parling103823763_p_arling
parring103222063_p_arring
parsing103819553_p_arsing
partings113513733_p_artings
partying14168893_p_artying
pasting103826553_p_asting
patting103722343_p_atting
pearling11912013_pearling
pharming16248143_pharming
pirating11314513_pirating
plaiting113113513_plaiting
planting113515383_planting
plating103823073_pla_ting
platting114813033_platting
porting103021783_p_orting
prating103424453_pra_ting
pupating1337683pupa_ting
quadrating2145653quadrating
redacting13612303redacting
redating102620173reda_ting
scarting113415263_scarting
sedating103014113seda_ting
smarting113212453_smarting
sparging122611133sp_arging
sparing104823873sp_ar_ing
sparking152812543sp_arking
sparling112714533sp_arling
sparring113112223sp_arring
spartina1037983sp_artina
spatting113111763sp_atting
spearing113216103spear_ing
spirting112913633sp_irting
splatting1235983splatting
sporting112415463sp_orting
spurting113111633sp_urting
starting93116173_starting
supporting1545563supporting
tarting84222653__tarting
thwarting1632763thwarting
umlauting1243163umlauting
unarming1138623u_narming
unbarring1236063unbarring
uncaring11312843uncar_ing
uncrating12813183uncrating
underling111514613underling
undertint10414863undertint
underwing141410883underwing
undraping1337333undraping
undrawing1436903undrawing
unearthing1454373unearthing
unhatting1335873unhatting
unplaiting1345503unplaiting
unvarying1644503unvarying
upbearing1435033upbear_ing
upcurling1453493upcurling
upcurving1742563upcurving
updart9310743updart___
updarted1244313updart_ed
updarts1034203updart__s
updiving1534223upd_iving
upgazing2133313upga_zing
upgirding1442373upgirding
upgrading1444903upgrading
uphoarding1742723uphoarding
uplifting1534963uplifting
upraising1237263upraising
uprearing1238373uprear_ing
uprooting1276903uprooting
upsetting1275563upsetting
upsoaring1244513upsoar_ing
upspring1335703upspr_ing
upstaring1235963upstar_ing
upsurging1343353upsurging
uptalking1643353uptalking
uptearing1236103uptear_ing
uptilting1234713uptilting
upturning1263373upturning

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411166.85621680.4
3Display Results1161160.0502320.0
 (SQL Overall)1786911167.06225303.2
 
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.