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

60 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
bead75937921bead_
beads85429501beads
beady114719921beady
adz1312332872__adz
bad67763162b_ad_
bade75140892b_ade
bads77048872b_ads
beach124623892beach
beaded104922422beaded
beader94623792beader
beadle93314682beadle
beak106534382bea_k
beaks115326622beaks
beaky146118022beaky
beam86939232bea_m
beams95328172beams
beamy126218572beamy
bean66443862bea_n
beano75421552beano
beans75734692beans
bear66844642bea_r
beard86024962beard
beards94116672beards
bears75739042bears
beast76338642beast
beat66168302bea_t
beats76042252beats
beau66137272bea_u
beaus75127112beaus
beaut75135212beaut
beaux146513212beaux
bed67950632be_d_
beds75937792be_ds
bedu75923702be_du
beedi8711662beedi
belady12489932belady
bend76435262bend_
bends85628972bends
bendy115017252bendy
bezazz1543982bezazz
blade85923332blade
brad75234342brad_
brads85528292brads
bread85523112bread_
breads95419212breads
bready124511182bready
dead65434242dead_
deads75726912deads
head87137172head_
heads95127112heads
heady125117262heady
lead56038852lead_
leads66028492leads
leady95618602leady
mead75531602mead_
meads85425322meads
read55942532read_
readd74617132readd
reads64835272reads
ready94821502ready

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit53800601.51635488.1
3Display Results60600.0134615.4
 (SQL Overall)178691601.85596329.4
 
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.