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

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

89 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
prattlingly175224(None) 
rattlingly1443651_rattlingly
pratingly1538372pra_t_ingly
prattling1246302prattling__
brattling1236003brattling__
drawlingly1843293dra_wlingly
gratingly1437403gra_t_ingly
pantingly1537863p_ant_ingly
ramblingly1842973_ramblingly
rantingly1337933_rant_ingly
rattling92510873_rattling__
rattlings10235513_rattling_s
sprattling1363053sprattling__
startlingly1542763startlingly
appallingly1951514appa_llingly
atoningly1365374__atoningly
bafflingly2242214_bafflingly
battling113110494_battling__
bracingly1745944bra__cingly
brittling1235544brittling__
bustlingly1643064_bustlingly
clatteringly1852464clatteringly
crashingly1964084cra_shingly
cripplingly2151584cripplingly
cuttingly1545374_cutt_ingly
darlingly1436054_da_rlingly
dartingly1436954_dart_ingly
dazzlingly2351994_dazzlingly
draggingly1743004dra_ggingly
dratting10389664dratt_ing__
driftingly1843674drift_ingly
drizzlingly2451294drizzlingly
exactingly2343484exact_ingly
failingly1636134_fa_ilingly
fittingly1645274_fitt_ingly
flatteringly1952564flatteringly
gallingly1435864_ga_llingly
graspingly1743364gra_spingly
gratifyingly2381014gratifyingly
grazingly2344944gra__zingly
grovelingly1951874grovelingly
growlingly1842844gr_owlingly
gruelingly1543504gr_uelingly
grumblingly2071534grumblingly
haltingly1645704_halt_ingly
juttingly2044584_jutt_ingly
lastingly1337244_last_ingly
paralyzingly305994paralyzingly
passingly1545784p_a_ssingly
patting103722344p_att_ing__
pettling1168214p_ettling__
pityingly1843954p__ityingly
placatingly1952334placatingly
platting114813034platt_ing__
potteringly1762944potteringly
poutingly1536484p_out_ingly
prating103424454pra_t_ing__
preachingly2242904preachingly
pressingly1646004pr_essingly
presumingly1952284presumingly
prettily1337284prett_i__ly
prettying1536044prettying__
pristinely1544794prist_inely
probingly1746014pr__obingly
promisingly1953004promisingly
provokingly2451804provokingly
pryingly1735544pr___yingly
pulingly1436804p___ulingly
puzzlingly2441884p_uzzlingly
rackingly1945124_ra_ckingly
ragingly1337864_ra__gingly
raspingly1535814_ra_spingly
ratting83822364_ratt_ing__
ravingly1537294_ra__vingly
retiringly1444514_retiringly
scathingly1943314sca_thingly
scatteringly1872494scatteringly
shatteringly1962384shatteringly
slantingly1445154slant_ingly
tattling9259474_tattling__
trustingly1444374trust_ingly
twattling1332694twattling__
unsettlingly1652104unsettlingly
vaultingly1743414_vaultingly
wailingly1635524_wa_ilingly
wastingly1636374_wast_ingly
wattling12258784_wattling__
wittingly1644804_witt_ingly
wrastling1335524wrastling__

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819899.34315928.4
3Display Results89890.0501780.0
 (SQL Overall)178691899.81618204.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.