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

208 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
langleys124510(None) 
langley1147451langley_
anglers84014822_anglers
angles74426702_angle_s
bangles103617412bangle_s
danglers103610592danglers
dangles93618422dangle_s
fangless1237662fangless
janglers16319372janglers
jangles154015682jangle_s
landlers94312832landlers
landless94011172landless
langrels9106172langrels
langues81211912langue_s
languets987242languets
manglers113311902manglers
mangles104021462mangle_s
tanglers92911972tanglers
tangles83920042tangle_s
wanglers123310032wanglers
wangles113416932wangle_s
aglets73915683_a_glets
agley96917333_a_gley_
aiglets84012913_aiglets
alleys95113303_a_lleys
aneles64626293_anele_s
angels74416173_ang_els
angelus8418463_angelus
angers75222543_ang_ers
angle64528873_angle__
angled84219093_angle_d
angler74017863_angle_r
anglos74413913_angl_os
ankles104818383_ankle_s
anklets114310413_anklets
anoles64827433_anole_s
antlers74014743_antlers
argles75218483_argle_s
baileys12388933ba_ileys
bangers104020353bang_ers
bangle94018953bangle__
barleys125011843ba_rleys
bunglers11398483bunglers
bungles104116763bungle_s
candlers114214103candlers
candles104422343candle_s
cangues10611823cangue_s
cantles94721413cantle_s
clangers114312343clang_ers
daggles103611913daggle_s
dandlers103912053dandlers
dandles94218533dandle_s
dangers94818213dang_ers
dangle84119303dangle__
dangled104013153dangle_d
dangler96912813dangle_r
dangly114212263dangl_y_
dingeys12458403ding_eys
dingles93818323dingle_s
dongles93212873dongle_s
eagles73819163ea_gle_s
eaglets84111663ea_glets
flagless1235403fla_gless
flangers123311373flang_ers
flanges113413273flang_e_s
gaggles103512593gaggle_s
galleys11369713ga_lleys
gangers94418603gang_ers
gangly113911583gangl_y_
gangrels1094973gangrels
gangues9149753gangue_s
gangways1643733gangways
gantlets9308903gantlets
garglers10418263garglers
gargles94214893gargle_s
gingeleys14272893gingeleys
glandless1134163glandless
gleys96514853___gleys
hagglers13326623hagglers
haggles123312483haggle_s
handlers124014143handlers
handles114020653handle_s
handless123512063handless
hangers113120813hang_ers
hantles104117513hantle_s
henleys1334843hen_leys
ingles74420873_ingle_s
jagless1537103ja_gless
jangle144416293jangle__
jangled164111563jangle_d
jangler153811833jangle_r
jangly174310603jangl_y_
jinglers16408763jinglers
jingles153816383jingle_s
jungles154112543jungle_s
kingless13288693kingless
kinglets13318583kinglets
laagers83411253laag_ers
labelers10249413labelers
laceless10239853laceless
lackeys16458263la_ckeys
lacqueys22132693lacqueys
ladlers84613573la_dlers
ladles74619543la_dle_s
lagers74826143la_g_ers
laggers94216243la_ggers
lampreys1542883lampreys
lancelets1144833lancelets
lancers93616643lan_cers
lances84824103lan_ce_s
lancets93411163lan_cets
lanciers10308543lanciers
landers84026213lan_ders
landler84113203landle_r
lanely93914483lanel_y_
lanes54946793lan__e_s
laneways1444573laneways
langlauf1243773langlauf
langlaufs1342103langlaufs
langrel8107033langre_l
langue71012173langue__
languet8713693langue_t
languors976153languors
langurs889103lang_urs
lankly13439623lankl_y_
lankness12237043lankness
lanners73618333lan_ners
lanolins8310533lanolins
largely1136703largely_
larges74824233larg_e_s
largess8408913larg_ess
laughers1235923laughers
lawless1037033la_wless
legless838013l_egless
lensless835583lensless
lineless82711943lineless
lingers84223303ling_ers
lingoes84014693lingoe_s
linseys1035083lin_seys
lintless82710013lintless
longers84819543long_ers
longes75925573long_e_s
longies82916553longie_s
longleaf1243663longleaf
longly10279603longl_y_
longness938553longness
longways1543873longways
lungees84412143lung_ees
lungers83817093lung_ers
lunges76123423lung_e_s
lunules738953lunule_s
maglevs1334693ma_glevs
magueys1333943ma_gueys
maneless102812343maneless
mangabeys1742033mangabeys
mangels103614493mang_els
mangers103521263mang_ers
manges94628943mang_e_s
mangey123614523mang_ey_
mangle93921323mangle__
mangled113615263mangle_d
mangler103215643mangle_r
mangoes104316133mangoe_s
manless93012933man_less
mantles94820703mantle_s
mantlets104611203mantlets
minglers113011293minglers
mingles103719003mingle_s
paisleys1333343paisleys
paneless102611763paneless
pangens103112063pang_ens
parleys125212373pa_rleys
parsleys1335083parsleys
planless1036813plan_less
plantlets1145013plantlets
pungles104013713pungle_s
raggles93813283raggle_s
rangers83621043rang_ers
ranges73826923rang_e_s
rankles113114543rankle_s
rankless12268233rankless
ringlets92910233ringlets
rungless956733rungless
sandless93212343sandless
sangers84421943sang_ers
singles83520433single_s
singlets93611473singlets
songless9218823songless
spangles1138893spangle_s
tangelos935743tangelos
tangle74019953tangle__
tangled94214633tangle_d
tangler83515073tangle_r
tangly104413913tangl_y_
tankless12267823tankless
tinglers93710593tinglers
tingles83818323tingle_s
twanglers1363433twanglers
twangles1245743twangle_s
valleys13407483va_lleys
waggles123812003waggle_s
wangle103817503wangle__
wangled123312413wangle_d
wangler113312653wangle_r
wingless122910023wingless
winglets12299593winglets
wranglers1344273wranglers
wrangles1237463wrangle_s

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622087.14020470.9
3Display Results2082080.0802600.0
 (SQL Overall)1786912087.64323379.7
 
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.