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

59 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
faradays154427(None) 
faraday1445631faraday_
caraways1636952caraways
faradaic1443652faradaic
farads104713272farad__s
faraway1645412faraway_
areaways1444493_areaways
armadas1038173_armada_s
arrays95311683_ar_rays
carabaos1238083carabaos
caracals12310763caracals
caravans1338623caravans
caraway1538133caraway_
facades1339033facad_es
fadeaways1942233fadeaways
fairways1743873fairways
fallaways1843163fallaways
farad95720683farad___
faradic1337693farad_ic
faradise12219393faradise
faradises13248983faradises
faradism14188373faradism
faradisms15256673faradisms
faradize21237823faradize
faradizes22237443faradizes
fardels11389893far_dels
fards96629843far_d__s
farfals13268503far_fals
farinas103215253farina_s
flyaways2042813flyaways
forays124813003for__ays
forebays1637263forebays
fracas11311993f_raca_s
frays116920103f_r__ays
hamadas1339673hamada_s
hardass1139753har_dass
layaways1743403layaways
macadams1545093macadams
maracas11313773maraca_s
margays1337493mar_gays
maydays1634493ma_ydays
nowadays1542263nowadays
panadas103312213panada_s
papadams15104783papadams
paraders113113123paraders
parades104121473parad_es
paradors113411903paradors
parados103816053parad_os
pardahs13289673par_dahs
parkways2043973parkways
parlays123910453par_lays
paydays1634433pa_ydays
radars71314673__radars
ramadas1039303ramada_s
sardars83112903sar_dars
taramas9612713tarama_s
tearaways1542973tearaways
washdays1842863washdays
workdays1942903workdays

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.420425454.8
2DLD Change Limit146162597.34619896.8
3Display Results59590.0301966.7
 (SQL Overall)178691597.79622920.9
 
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.