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

83 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
forestay144819(None) 
forestal11410281forestal
forestays1546621forestays
forestry1446721forestry
forebay1538132fore_bay
foreplay1645672foreplay
foresaw1377132fores_aw
forest94926742forest__
forestage1346972forestage
forestall1246912forestall
forested12312462forested
forester11313672forester
forestial1247232forestial
forests104114952forest_s
homestay1645812homestay
agrestal945653agrestal
bobstay1443983bo_bstay
borstal939043bor_stal
corsetry1365573corsetry
crestal9312133_crestal
daresay1135433dares_ay
domesday1542313domesday
festal94213563f__estal
fiesta938123f_iesta_
fiestas1038433f_iestas
fireclay1644183fireclay
firstly1335643fir_stly
floristry1542713floristry
foetal9311883fo_e_tal
foray115023973for___ay
forebays1637263fore_bays
forebear1346383forebear
forebody1745153forebody
foreby1438633fore__by
foredate12310913foredate
forehead1537893forehead
forelady1545073forelady
foreman12312363fore_man
forepaw1595613fore_paw
forepeak17134783forepeak
foreplays1745043foreplays
foreran10311793fore_ran
fores85847103fores___
foresaid1247803foresaid
foresail1147823foresail
foresee10414333fores_ee
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
foreshank1944673foreshank
foreshow1785893foreshow
foreside12310303foreside
foreskin1547023foreskin
forespake18105233forespake
forespeak1843473forespeak
forestages1446733forestages
forestalls1345803forestalls
foresters12312533foresters
foresting13311363foresting
forestland1453023forestland
foreswear1543513foreswear
foretop12117893fore_top
forty114824273for__t_y
freeway1635603f_reeway
freshly16286833f_reshly
fretsaw1343923f_retsaw
fretty1249223f_re_tty
frosty124710633f_rost_y
frowsty16464983frowst_y
frusta937453f_rusta_
homestays1744713homestays
honestly14355933honestly
honesty13378053honest_y
lodestar944413lodestar
modestly14375583modestly
modesty13476983modest_y
outstay1047683_outstay
overstay1436733_overstay
podesta1036763podesta_
podestas1146853podestas
polestar1047113polestar
resay85320543__res_ay
sorest65028003sorest__

Search took 7 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.406440125.6
2DLD Change Limit146162836.53022383.2
3Display Results83830.0332515.2
 (SQL Overall)178691836.96925640.8
 
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.