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

54 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
dewfalls154307(None) 
dewfall1453761dewfall_
befalls12349122be_falls
deadfalls1443142deadfalls
downfalls1643142downfalls
refalls103312242re_falls
ashfalls1443433ashfalls
beefalos1343663beefalos
befall114410643be_fall_
begalls10319163be_galls
bewails1277553bew_ails
catfalls1347063catfalls
deadfall1343313deadfall_
deals65435343de__a_ls
decals93717713de_ca_ls
defaces133213403de_faces
defames132812253de_fames
defangs1235363de_fangs
defats105114553de_fa_ts
default1147893de_fault
defaults1243333de_faults
defiles114016843de_files
defuels11296983de_fuels
dells66630943de___lls
denials84114133denia_ls
dentally121110063dentally
dentals83915393denta_ls
derails84216393de_rails
desalts839573de_salts
details84214043de_tails
dewans105215143dew_a_ns
dewars105117073dew_a_rs
dewaxes18297843dew_axes
dewclaws1751873dewclaws
dewlaps1334663dewla_ps
dewools1145593dew_ools
downfall1543633downfall_
drywalls1542953drywalls
dwells10417713d_w_ells
evenfalls1562673evenfalls
falls85727653___falls
icefalls1344253icefalls
infalls1038943_infalls
inwalls1037283inw_alls
lowballs1364393lowballs
outfalls1138143outfalls
pitfalls1345373pitfalls
recalls92613623re_calls
refall94314393re_fall_
refills103711423re_fills
seawalls1145233seawalls
sidewalls1344283sidew_alls
snowfalls15113083snowfalls
walls85529383__w_alls

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.470380193.6
2DLD Change Limit146162547.34319904.9
3Display Results54540.0163375.0
 (SQL Overall)178691547.82922824.2
 
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.