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

108 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
bewilder143413(None) 
bewilders1543811bewilders
beholder1435052beholder
bewailer1334862bewail_er
bewildered1742292bewildered
bowlder13407482bow_lder
builder1037572b_uilder
rewinder12317662rewinder
wilder103616472__wilder
bailer85425253b_ail_er
balder95318863b__alder
bawler114315053baw_l_er
beader94623793be__ader
bedder104215793be__dder
bediaper1344933bediaper
beetler938033beetl_er
befinger1434643befinger
beginner1173953beginner
begirded1334173begirded
beguiler1154063beguil_er
beheader1436043beheader
beholden1443593beholden
beholders1544933beholders
belier84423563be__lier
believer13448423believer
belter84720963be__lter
bender95223303be__nder
beside95114613besi_de_
besides104814533besi_des
besieger1144673besieger
betide95115973beti_de_
betided114810203beti_ded
betides104915263beti_des
beveler124010683bevel_er
beveller13387663beveller
bewailed1435343bewail_ed
bewailers1434233bewail_ers
bewigged1643383bewigged
bewildering1872703bewildering
bewinged1584473bewinged
bewitcher1943003bewitcher
bewrayer1643733bewrayer
bidder104114863b__idder
bider85728373b__i_der
bilker124913443b__ilker
biller84923483b__iller
binder94422873b__inder
birder94915493b__irder
blinder103912983b_linder
boiler84319273b_oil_er
bolder94820933b__older
boulder103411343b_oulder
bowlders14306493bow_lders
bowler114217313bow_l_er
braider105112993brai_der
brailler1036883brailler
bridler103811073b_ridler
broider103912973broi_der
broiler92911753broil_er
builded1136473b_uilded
builders1146743b_uilders
ceiler84013963ce_il_er
decider114213183deci_der
defiler113911883defil_er
derider93214973deri_der
desilver12286503desilver
dewier104013463dewi__er
eider64624743_e_i_der
elder64020023_e__lder
evildoer1241933_evildoer
eviler94811893_evil_er
eviller1056673_eviller
exiler134712183_exil_er
gelder84613713ge__lder
gilder84415533__gilder
guilder945913_guilder
jeweler1735053jewel_er
jeweller1844123jeweller
lewder10479613lew__der
melder93915813me__lder
mewler113510233mew_l_er
milder93818453__milder
pewholder1842723pewholder
refilter1137153refilter
regilded1135543regilded
reminder113110513reminder
resider84615803resi_der
resilver11337503resilver
resolder9259233resolder
reviler104314973revil_er
rewarder12208233rewarder
rewelded1335893rewelded
rewiden1137533rewi_den
rewinded13277673rewinded
rewinders13246503rewinders
swiller103211663_swiller
unwinder1235613unwinder
veiler93814353ve_il_er
weirder1144923we_irder
welder102914413__welder
widder112913973__widder
wider94826353__wi_der
wielder11197673__wielder
wilded113714503__wilded
wilders113513503__wilders
wilier93217073__wilier
willer94021063__willer
winder104025263__winder

Search took 7 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.420425454.8
2DLD Change Limit1461621086.47022590.7
3Display Results1081080.0462347.8
 (SQL Overall)1786911086.93625762.8
 
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.