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

137 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
twanglers136343(None) 
tanglers92911971t_anglers
twangers12226061twang_ers
twangler1244111twangler_
twangles1245741twangle_s
wanglers123310031_wanglers
anglers84014822__anglers
danglers103610592_danglers
janglers16319372_janglers
manglers113311902_manglers
stranglers11396822stranglers
tangler83515072t_angler_
tangles83920042t_angle_s
tinglers93710592t_inglers
twaddlers14343612twaddlers
twanger11327432twang_er_
twangier1254242twangier_
twangle1145802twangle__
twangled1364172twangle_d
twinklers1633062twinklers
wangler113312652_wangler_
wangles113416932_wangle_s
wranglers1344272wranglers
angers75222543__ang_ers
angler74017863__angler_
angles74426703__angle_s
antlers74014743__antlers
bangers104020353_bang_ers
bangles103617413_bangle_s
bunglers11398483_bunglers
candlers114214103_candlers
chandlers15387673chandlers
changers144313203chang_ers
clangers114312343clang_ers
dandlers103912053_dandlers
dangers94818213_dang_ers
dangler96912813_dangler_
dangles93618423_dangle_s
entanglers1163033entanglers
fangless1237663_fangless
finaglers13173893finaglers
flangers123311373flang_ers
gangers94418603_gang_ers
garglers10418263_garglers
grangers103011973grang_ers
hagglers13326623_hagglers
handlers124014143_handlers
hangers113120813_hang_ers
jangler153811833_jangler_
jangles154015683_jangle_s
jinglers16408763_jinglers
landlers94312833_landlers
langleys1245103_langleys
mangers103521263_mang_ers
mangler103215643_mangler_
mangles104021463_mangle_s
minglers113011293_minglers
rangers83621043_rang_ers
sangers84421943_sang_ers
shinglers13246443shinglers
spangles1138893spangle_s
stragglers12305253stragglers
strangers104112163strang_ers
strangler10369473strangler_
strangles103011553strangle_s
swagers114211023swa_g_ers
swaggers13407223swa_ggers
swindlers13306033swindlers
swingers123710423swing_ers
swingles12319543swingle_s
tacklers143010773t_acklers
taggers93514193t_a_ggers
tailers73720183t_a_ilers
talers64628143t_a__lers
tanagers9259003t_anagers
tangelos935743t_angelos
tangier83013903t_angier_
tangle74019953t_angle__
tangled94214633t_angle_d
tanglier948073t_anglier_
tankers113416913t_an_kers
tankless12267823t_ankless
tanners74018393t_an_ners
tattlers8369693t_attlers
teaselers9165843teaselers
thalers106212263tha__lers
thankers15297833than_kers
thankless1633203thankless
tingler83613343t_ingler_
tingles83818323t_ingle_s
tinklers12298183t_inklers
togglers10276953t_ogglers
tongers84116013t_ong_ers
trailers82912923tra_ilers
tramplers13305883tramplers
transfers1238053transfers
travelers12266773travelers
trawlers113310203tra_wlers
triangles1035743triangle_s
trundlers10215003trundlers
tunnelers953463tunnelers
twaddler13314643twaddler_
twaddles13315723twaddle_s
twanged12387273twang_e_d
twangiest1355223twangiest
twangling1434453twangling
twangs10358093twang___s
twankies1535893twankie_s
twattles1154383twattle_s
twiddlers14313693twiddlers
twigless1293663tw_igless
twiners10459633twin__ers
twinges11409453twing_e_s
twinkler1564073twinkler_
twinkles1535073twinkle_s
twirlers11274303tw_irlers
wabblers15398993_wabblers
waddlers13298333_waddlers
wafflers17306323_wafflers
wagers105122203_wa_g_ers
waggers124613083_wa_ggers
waggles123812003_waggle_s
wailers103916803_wa_ilers
walers94824463_wa__lers
wanders114221333_wan_ders
wangle103817503_wangle__
wangled123312413_wangle_d
wankers144514713_wan_kers
wanters104420093_wan_ters
warblers13319103_warblers
warslers11328073_warslers
wigglers13257213_wigglers
wingers113921483_wing_ers
wingless122910023_wingless
winglets12299593_winglets
wrangler1245473wrangler_
wrangles1237463wrangle_s

Search took 9 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.420425454.8
2DLD Change Limit1486411377.55019687.5
3Display Results1371370.0433186.0
 (SQL Overall)1786911378.01322300.1
 
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.