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

81 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
flatteringly195256(None) 
clatteringly1852461clatteringly
falteringly1843142f_alteringly
flattering1498742flattering__
glitteringly1751862glitteringly
scatteringly1872492scatteringly
shatteringly1962382shatteringly
unflatteringly2161152unflatteringly
banteringly1743873_banteringly
blattering13108713blattering__
blisteringly1852293blisteringly
blusteringly1852033blusteringly
clattering13109233clattering__
flaringly1646253fla___ringly
flattening14115103flattening__
fleeringly1743723fl__eeringly
flickeringly2561233flickeringly
flittering1486503flittering__
fluttering14106293fluttering__
potteringly1762943_potteringly
slatternly1342233slatter_n_ly
totteringly1552553_totteringly
battering122715144_battering__
blathering16107584blathering__
blunderingly1951644blunderingly
chattering16108644chattering__
cluttering13106834cluttering__
faltering132211114f_altering__
fathering161010094f_athering__
fatiguingly1951544f_atiguingly
fattening13287834f_attening__
feathering17108794feathering__
featherings18105374feathering_s
fettering132310514f_ettering__
fittingly1645264f_itt__ingly
flaggingly1942824fla__ggingly
flamingly1845024fla___mingly
flatteries1347414flatteri__es
flattery14338294flatter____y
flatting123511254flatt__ing__
flauntingly1842184fla_untingly
fleetingly1743584fl__eetingly
flustering14105934flustering__
frittering14105624frittering__
glaringly1445824gla___ringly
glittering1296004glittering__
hearteningly1972434hearteningly
lastingly1337234_last__ingly
lathering13912254_lathering__
latterly1136064_latter___ly
leeringly1345964_l__eeringly
lettering102112074_lettering__
letterings11226004_lettering_s
lingeringly1653164_lingeringly
littering102411984_littering__
mattering122314054_mattering__
nattering102212214_nattering__
pattering122314424_pattering__
plastering1339244plastering__
plasterings1444744plastering_s
prattlingly1752244pratt_lingly
quaveringly2752194qua_veringly
rattlingly1443644_ratt_lingly
scattering1398014scattering__
scatterings14103974scattering_s
shattering1498284shattering__
slantingly1445144slant__ingly
slathering14108284slathering__
smattering1397584smattering__
smatterings14103844smattering_s
spattering13107794spattering__
splattering1454544splattering__
staggeringly1851364staggeringly
swaggeringly2151194swaggeringly
swelteringly1951734swelteringly
tattering102212324_tattering__
unfalteringly2061794unfalteringly
unflattering1672044unflattering__
waveringly2043724_wa_veringly
witheringly2152524_witheringly
yattering132410444_yattering__

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790816.23620011.2
3Display Results81810.0431883.7
 (SQL Overall)178691816.41927837.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.