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

129 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
bladdery1534458(None) 
bladder11429151bladder_
bladders12397801bladders
badder103817512b_adder_
blader93618582bla_der_
bladers104214682bla_ders
blander103715162blander_
gladder10398312gladder_
ladder84617622_ladder_
ladders94115172_ladders
adder75419593__adder_
adders84315703__adders
baddest112611143b_addest
baddy125016023b_add__y
badger105415083b_adger_
badgerly1543283b_adgerly
badgers114812653b_adgers
bakery155911003b_a_kery
balder95318863b_alder_
bander93928223b_ander_
banders104324563b_anders
battery124911813b_attery
bawdry15516463b_awd_ry
beader94623793bea_der_
beaders104120183bea_ders
beadier103513913beadier_
beanery1237563bea_nery
bedder104215793b_edder_
bedders113513383b_edders
bidder104114863b_idder_
bidders114012313b_idders
bilander1136673bilander_
bilanders1235963bilanders
bindery13459833b_indery
blabber10418923blabber_
blabbers11308153blabbers
blacker154513513blacker_
bladdernut14171663bladdernut
blade85923333bla_de__
bladed104717763bla_de_d
blades95221253bla_de_s
blaeberry1642643blaeberry
blamer104417143bla_mer_
blamers115314213bla_mers
blandest113811043blandest
blandly1336043bland_ly
blanker134612023blanker_
blarney12174763blarne_y
blaster94017303blaster_
blasters104116143blasters
blather125314203blather_
blathers134713793blathers
blatter94415653blatter_
blatters104414093blatters
blazer174414023bla_zer_
blazers184811683bla_zers
blazonry2242163blazonry
bleeder10359643bleeder_
bleeders11448453bleeders
blender104613843blender_
blenders115210993blenders
blinder103912983blinder_
blinders113911143blinders
blistery13418713blistery
blonder104011943blonder_
bloomery15335693bloomery
blubbery14294783blubbery
bludger11419563bludger_
bludgers12397853bludgers
blunder103813153blunder_
blunders113911343blunders
blustery13368003blustery
boarder103910323boarder_
boarders11408623boarders
bouldery14295013bouldery
bradded12388713bradde_d
braider105112993braider_
braiders114110573braiders
brander103915823brander_
branders114313093branders
bravery15428133bra_very
broidery14356083broidery
budder104314813b_udder_
budders113812103b_udders
cladded12356923cladde_d
clattery13378193clattery
doddery13516853_doddery
flackery20295243flackery
flattery14338293flattery
gadder93714713_gadder_
gadders103611503_gadders
gaudery1234743_gaudery
gladded11357453gladde_d
gladden10376313gladde_n
gladdens11364463gladdens
gladdest11145843gladdest
gladier93810993gladier_
glanders103811503glanders
glaziery21413693glaziery
laddered1136743_laddered
lader65633723_la_der_
laders74927763_la_ders
ladler74314933_ladler_
ladlers84613573_ladlers
lander74028483_lander_
landers84026213_landers
larder73720973_larder_
larders83516943_larders
lathery133911123_lathery
lauder73815013_lauder_
lauders84012893_lauders
madder103515593_madder_
madders113513213_madders
padder103415493_padder_
padders113312873_padders
plastery13279703plastery
plodder1146003plodder_
plodders1235523plodders
sadder82916973_sadder_
saddlery13274913_saddlery
shuddery16263413shuddery
slabbery15375773slabbery
slander84015443slander_
slanders94014013slanders
slavery13407893sla_very
sledder9399203sledder_
sledders10257373sledders
wadder114215483_wadder_
wadders123812443_wadders

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.406440125.6
2DLD Change Limit1461621296.61022112.3
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.06225303.2
 
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.