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

64 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
bhangra134318(None) 
bhangras1443691bhangras
bhang115512922bhang__
bhangs12449662bhang_s
hangar104114512_hangar
anga56831353__ang_a
angora71111573__angora
angry9310863__angry
antra56521923__antra
banana83213413b_anana
banda85223103b_an_da
bandora1038813b_andora
bang74837003b_ang__
banged104923723b_anged
banger94423633b_anger
bangers104020353b_angers
bangle94018953b_angle
bangs85627773b_ang_s
beanery1237563beanery
bhakta1533653bha_kta
bharal1138893bha__ral
bravura1253603bravura
bwana10310243bwan__a
chakra15437533cha_kra
chancre14348783chancre
chang115418563chang__
change124116753chang_e
changed144214143changed
changer134215543changer
changers144313203changers
changes134517583changes
changs125215373chang_s
chantry15388223chantry
fanga96119623_fang_a
hang85535553_hang__
hangars114313493_hangars
hanged114222393_hanged
hanger104023253_hanger
hangers113120813_hangers
hangman1337813_hangman
hangs95726723_hang_s
hangtag1244533_hangtag
hangul1049213_hangul
hangup1277293_hangup
haniwa1236743_haniwa
hansa85416783_han_sa
hungry1334973_hungry
jagra1338173_ja_gra
manga85026203_mang_a
mantra84116093_mantra
panga85323533_pang_a
pangram1239023_pangram
sanga66023793_sang_a
sangar73617683_sangar
sangria838113_sangria
shanghai1542643shanghai
tanga64923693_tang_a
tangram1038073_tangram
tantra63713353_tantra
whang124813383whang__
whanged15447613whanged
whangee14268613whangee
whangs13439723whang_s
yantra9449623_yantra

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 Filter1786911340270.420425454.8
2DLD Change Limit134027646.79619721.5
3Display Results64640.0164000.0
 (SQL Overall)178691647.23224708.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.