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

59 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
belittled124303(None) 
belittle1044051belittle_
belittler1142491belittler
belittles1143871belittles
befitted14305722befitt_ed
belittlers1242022belittlers
brittled11186092b_rittled
battled104213123b__attled
bedimpled1742593bedimpled
bedirtied1393733bedirtied
bedotted1234983bedott_ed
beetled1038223be__etled
begirdled1442403begirdled
belated103520013bel_at_ed
belied95022163beli___ed
believed14427923beli_eved
belittling1343193belittling
belled94626193bel___led
belted94020633bel__t_ed
bemingled1544083bemingled
bemisted1368383bemist_ed
bepimpled1842043bepimpled
besotted1135843besott_ed
betted94721163be__tt_ed
bewitched2043233bewitched
bitted94418483b__itt_ed
blatted104812713b_latt_ed
blitzed19336533b_li_tzed
blotted103911833b_lott_ed
bottled104611233b__ottled
brattled11196723b_rattled
bristled11187343b_ristled
brittle9168603b_rittle_
brittler10165983b_rittler
brittles10178653b_rittles
cuittled1133993_cuittled
delisted10310563delist_ed
demitted12288773demitt_ed
emitted103010853_emitt_ed
entitled967503_entitled
fettled11378933fe__ttled
flitted114011643_flitt_ed
kittled12388193__kittled
little63312163__little_
littler7348553__littler
littles73212783__littles
mettled103510543me__ttled
nettled8339943ne__ttled
pettled103611513pe__ttled
rebottled1243433rebottled
refitted12309413refitt_ed
relisted9312623relist_ed
remitted113312073remitt_ed
resettled1035303resettled
retitled9339553reti_tled
settled83210873se__ttled
slitted83513313_slitt_ed
vittled11347343__vittled
whittled1594913_whittled

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.843211970.3
2DLD Change Limit148641596.92321470.6
3Display Results59590.0134538.5
 (SQL Overall)178691597.77922970.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.