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

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

43 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
unflatteringly216115(None) 
flatteringly1952562__flatteringly
unfalteringly2061792unf_alteringly
unflattering1672042unflattering__
clatteringly1852463__clatteringly
falteringly1843154__f_alteringly
flattering1498744__flattering__
glitteringly1751864__glitteringly
scatteringly1872494__scatteringly
shatteringly1962384__shatteringly
uncluttering1551804uncluttering__
unfaltering1543264unf_altering__
unfettering1543704unf_ettering__
unflaggingly2151544unfla__ggingly
unwaveringly2251914un_wa_veringly
banteringly1743875___banteringly
blattering13108715__blattering__
blisteringly1852295__blisteringly
blusteringly1852035__blusteringly
clattering13109235__clattering__
enfettering1543235enf_ettering__
flaringly1646265__fla___ringly
flattening14115105__flattening__
fleeringly1743725__fl__eeringly
flickeringly2561235__flickeringly
flittering1486505__flittering__
fluttering14106295__fluttering__
nattering102212215_n__attering__
potteringly1762945___potteringly
slatternly1342235__slatter_n_ly
splattering1454545_splattering__
swelteringly1951735swel__teringly
totteringly1552555___totteringly
unfadingly1843425unf_a___dingly
unfailingly1853185unf_a__ilingly
unfastening1572785unf_astening__
unfeelingly1853135unf___eelingly
unflinchingly256975unfl_inchingly
unilaterally1553055unila_ter_ally
unsettlingly1652105un_sett_lingly
unsparingly1753535unspa___ringly
untiringly1445015un____tiringly
unwittingly1852785un_witt__ingly

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 Filter178691950240.360496363.9
2DLD Change Limit95024435.61016938.3
3Display Results43430.0331303.0
 (SQL Overall)178691436.00329766.9
 
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.