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

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

100 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
wangled12331241(None) 
angled84219091_angled
dangled104013151dangled
jangled164111561jangled
mangled113615261mangled
tangled94214641tangled
twangled1364171twangled
waggled13389361waggled
wangle103817511wangle_
wangler113312651wangler
wangles113416931wangles
wrangled1335591wrangled
aneled74719282_aneled
angeled93211512_angeled
angle64528882_angle_
angler74017862_angler
angles74426702_angles
ankled114313482_ankled
argled85314552_argled
banged104923732bang_ed
bangle94018962bangle_
bangles103617412bangles
bungled114112242bungled
canaled103615562canaled
candled113815742candled
daggled11329462daggled
dandled103313542dandled
danged94819492dang_ed
dangle84119312dangle_
dangler96912812dangler
dangles93618422dangles
eagled82914042ea_gled
fanged114318232fang_ed
gaggled11359912gaggled
ganged94619202gang_ed
gargled104210672gargled
haggled13359282haggled
handled124114532handled
hanged114222402hang_ed
jangle144416302jangle_
jangler153811832jangler
jangles154015682jangles
jingled164111062jingled
jungled16349642jungled
langley1147452langley
mangle93921332mangle_
mangler103215642mangler
mangles104021462mangles
mantled104113392mantled
mingled113612732mingled
paneled10612572paneled
panged104722342pang_ed
pungled114210082pungled
ranged84824322rang_ed
rankled123910652rankled
singled93914682singled
spangled1236152spangled
swingled13337432swingled
tanged84622512tang_ed
tangle74019972tangle_
tangler83515082tangler
tangles83920052tangles
tangoed9318842tangoed
tingled93712802tingled
twanged12387282twang_ed
twangle1145812twangle_
twangler1244112twangler
twangles1245742twangles
wabbled153311442wabbled
waddled133611642waddled
waffled17357522waffled
waged104822782wa_g_ed
wagged124616122wa_gged
waggle113612302waggle_
waggles123812002waggles
wailed104823592wa_iled
waled94331002wa__led
walled104021292wa_lled
wambled153610752wambled
wandle105316662wandle_
waned95831782wan__ed
wanglers123310032wanglers
wanked144517152wan_ked
wanned104318012wan_ned
wanted104319722wan_ted
warbled133212162warbled
warsled112910442warsled
wattled113610502wattled
wauled104713962wa_uled
wawled133811702wa_wled
whanged15447612whang_ed
wiggled13299602wiggled
windled123713482windled
winged114620832wing_ed
winglet113115982winglet
winkled15299592winkled
wintled11339842wintled
wrangle1137382wrangle_
wrangler1245472wrangler
wrangles1237472wrangles

Search took 5 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 Filter1786911076710.406440125.6
2DLD Change Limit1076711003.95327237.8
3Display Results1001000.0333030.3
 (SQL Overall)1786911004.39240685.6
 
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.