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

70 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
dewfall145376(None) 
dewfalls1543071dewfalls
befall114410642be_fall
deadfall1343312deadfall
downfall1543632downfall
refall94314392re_fall
ashfall1343943ashfall
beefalo1244083beefalo
befalls12349123be_falls
befell11428713be_fell
begall92610723be_gall
bewail1189583bew_ail
catfall1237393catfall
deadfalls1443143deadfalls
deafly13389123deaf_ly
deal56347413de__a_l
deals65435343de__als
dealt65234283de__alt
decal85523233de_ca_l
decals93717713de_cals
dedal75719023de_da_l
deface123113863de_face
defame123212433de_fame
defang1137753de_fang
defat95426693de_fa_t
defats105114553de_fats
default1147893de_fault
defile105216663de_file
deftly1336533de_ftly
defuel10348933de_fuel
dell56938203de___ll
denial74720513denia_l
denials84114133denials
dental74319173denta_l
dentally121110063dentally
dentals83915393dentals
derail74218813de_rail
dermal93614343derma_l
desalt7518313de_salt
detail74516433de_tail
dewan95718043dew_a_n
dewans105215143dew_ans
dewar95817733dew_a_r
dewars105117073dew_ars
dewax165510853dew_a_x
dewclaw1651793dewclaw
dewily1338343dew_ily
dewlap1264843dewla_p
dewlaps1334663dewlaps
dewool1047403dew_ool
dewools1145593dewools
downfalls1643143downfalls
drywall1443653drywall
dwell9519853d_w_ell
evenfall1492943evenfall
fall75535313___fall
icefall1254303icefall
infall939403_infall
inwall938343inw_all
lowball1275503lowball
outfall1039683outfall
pitfall1245823pitfall
recall83815723re_call
refalls103312243re_falls
refell94214443re_fell
refill94514053re_fill
seawall1046203seawall
sidewall1244803sidew_all
snowfall14133303snowfall
wall76236103__w_all

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 Filter1786911340270.390458182.1
2DLD Change Limit134027706.89019452.4
3Display Results70700.0332121.2
 (SQL Overall)178691707.31324434.7
 
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.