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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
strangling125640(None) 
straggling1344301straggling
estranging1246022estrang_ing
spangling1336372s_pangling
stanging104013652st_ang_ing
straddling1343642straddling
stranding1149652stran_ding
strandline1145362strandline
strangering1345192strangering
stringing1139752string_ing
struggling1342502struggling
tangling101712542_t_angling
twangling1434452_twangling
wrangling1456222_wrangling
angling92816043___angling
arranging1156303arrang_ing
astringing1245773astring_ing
brandling1348253_brandling
crankling16147293_crankling
dangling112611233__dangling
deranging1238063derang_ing
draggling1354613_draggling
embrangling1782273embrangling
entangling1244323entangling
gangling112411403__gangling
haranguing1543123haranguing
jangling17249623__jangling
mangling122312623__mangling
outranging1238003outrang_ing
pranging123012723_prang_ing
ranging94120263__rang_ing
rankling132610113__rankling
sandling102214413s__andling
scantling12107233s_cantling
scrabbling1742853scrabbling
scragging1435273scra_gging
scraighing1742933scraighing
scrambling1743473scrambling
scrawling15195583scra_wling
shingling14136973s_hingling
singling101913003s__ingling
slanging103413433s_lang_ing
spraddling1542313spraddling
sprattling1363053sprattling
sprawling15175123spra_wling
springeing1444373springeing
springing1338743spring_ing
sprinkling1743823sprinkling
stabling112913653st_a_bling
stagging113310513st_a_gging
staging93818373st_a_g_ing
staling83925423st_a__ling
stalling95116703st_a_lling
stanching1538083st_anching
standing103413633st_an_ding
staning83922243st_an__ing
stapling112813153st_a_pling
starling93017123st_a_rling
startling1037373st_artling
starveling1444263starveling
stealing93416603stea__ling
stinging103213453st_ing_ing
strafing122111193stra__fing
stragglier1243503stragglier
straighting1644073straighting
straining10410563stra_ining
strandlines1244973strandlines
strangle98411503strangl__e
strangled11268983strangl_ed
strangler10369473strangl_er
stranglers11396833stranglers
strangles103011563strangl_es
strangulating1583263strangulating
strapping1436993stra_pping
stravaging1543723stravaging
strawing122411623stra__wing
straying122912693stra__ying
streeling10189483str_eeling
strickling1744953strickling
stringings1245233string_ings
stripling1257783str_ipling
strolling10238793str_olling
strunting1037873strun_ting
surcingling1551823surcingling
swingling14156203s_wingling
syringing1435883syring_ing
tanging93419533_t_ang_ing
tangoing10177893_t_angoing
tingling102210823_t_ingling
trachling1537823_trachling
trailing92916093_tra_iling
trameling1249053_trameling
trampling1436973_trampling
trancing112812023_tran_cing
traveling1349053_traveling
trawling122710783_tra_wling
trindling1137133_trindling
trundling1135003_trundling
twanging13287063_twang_ing
untangling1244123untangling
wangling132310993__wangling

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 Filter1786911406030.423422437.4
2DLD Change Limit1406031016.64021175.2
3Display Results1011010.0631603.2
 (SQL Overall)1786911017.12625075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.