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 “bediapers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

57 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
bediapers144433(None) 
bediaper1344931bediaper_
bediapered1642382bediapered
bedmakers1844382bedmakers
bedrapes1386962bedrape_s
diapers104713912__diapers
beaders104120183be__aders
beakers134216873be__akers
bearers94619593be__arers
beaters94925043be__aters
beavers124417323be__avers
beboppers1742323beboppers
bedcovers1783563bedcovers
bedders113513383bed__ders
bedeafens1542413bedeafens
bediapering1763043bediapering
bedimples1642973bedimples
bedizens2044423bedi_zens
bedmaker1744933bedmaker_
bedmates1349183bedmate_s
bedrape1277693bedrape__
bedraped1455813bedrape_d
bedwarmers1842703bedwarmers
beepers113612383be__epers
befingers1544103befingers
beginners1283613beginners
behavers16205613be_havers
beheaders1545153beheaders
bejabers1933633be_jabers
belayers13298143be_layers
beliers94617383beli__ers
believers14346633believers
bereavers1446123bereavers
besiegers1244053besiegers
betrayers1445013betrayers
bewailers1434233bewailers
bewilders1543813bewilders
bewrayers1743483bewrayers
dialers83614303__dialers
diaper94513113__diaper_
diapirs10347643__diapirs
dippers123615183__dippers
drapers105313353__drapers
edifiers12336673_edifiers
endpapers1443643endpapers
escapers12337413_escapers
heapers123616673he__apers
kidnapers1652473kidnapers
leapers93716663le__apers
mediates112814063mediate_s
mediators1248923mediators
pedalers11239393ped_alers
petnapers1343823petnapers
reapers93520453re__apers
redrawers1344353redrawers
repapers1258833re_papers
reshapers1435493reshapers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641576.73322076.5
3Display Results57570.0331727.3
 (SQL Overall)178691577.18924856.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.