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

83 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
uptalking164335(None) 
outtalking1545482outtalking
peptalking1943252peptalking
stalking133512222_stalking
talking123815822__talking
untacking1636642untacking
uptilting1234712uptilting
appalling1444923appalling
attacking1635323attacking
balking143717353__balking
betaking153010153beta_king
calking144617783__calking
chalking183310063_chalking
metaling111613723metal_ing
metalling1249593metalling
outasking1437313outasking
outtasking1545723outtasking
outwalking1845283outwalking
packing164420723_p_acking
paiking143814813_p_aiking
paling93530133_p_al_ing
palling104024483_p_alling
palming123914013_p_alming
palping124112873_p_alping
parking143423043_p_arking
peaking144317693_pea_king
pealing104123203_peal_ing
planking153513013_planking
pranking153813383_pranking
psalming1375473_psalming
retacking1658973retacking
retaking133114283reta_king
spalling113213463sp_alling
spanking153911973sp_anking
sparking152812543sp_arking
speaking153212493spea_king
stacking154215083_stacking
staking123919803_sta_king
staling83925423_stal_ing
stalkings14314983_stalkings
stalling95116703_stalling
tacking144421483__tacking
taking114725953__ta_king
talcing103111633__talcing
talcking1567083__talcking
talkings13358403__talkings
tanking123918793__tanking
tasking124616323__tasking
totaling9610303total_ing
totalling1036523totalling
unbaling11310683unbal_ing
uncaking1539463unca_king
unmaking1538133unma_king
unmasking1635263unmasking
unpacking1835133unpacking
unstacking1744993unstacking
untracking1746933untracking
untucking1644693untucking
upcasting1434823upcasting
updarting1334333updarting
updating1236593upda_ting
upfling1337093up_fl_ing
upfolding1642943upfolding
upgazing2133313upga_zing
upholding1643373upholding
uplinking1634623uplinking
uppiling1335853uppil_ing
upraising1237263upraising
uprating11311113upra_ting
upscaling1444653upscal_ing
upstaging1344113upsta_ging
upstanding1443713upstanding
upstaring1235963upsta_ring
upstarting1343883upstarting
uptalk1234653uptalk___
uptalked1533053uptalk_ed
uptalks1333723uptalk__s
uptearing1236103uptearing
uptossing1243523uptossing
upturning1263373upturning
upwafting1842063upwafting
upwelling1535233upwelling
walking154013303__walking

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 Limit148641836.20323962.8
3Display Results83830.0332515.2
 (SQL Overall)178691836.39227955.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.