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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
foredates1331005(None) 
foredate12310911foredate_
foredated1447681foredated
corelates11314862corelates
foredoes12310802fored_oes
forefaces1747132forefaces
forenames1447542forenames
foretastes1375592foretastes
formates132814292for_mates
predates11615812_predates
redates83423872__redates
airdates939723air_dates
antedates1048613antedates
borates94823013bor__ates
boreases10310253bore_ases
chordates1547683chor_dates
cocreates132611883cocre_ates
conepates13912283conepates
copemates1549483copemates
cordages12310113cor_dages
cordate10315223cor_date_
cordites11314623cor_dites
corelate10516013corelate_
corelated12411823corelated
coronates1110816923coronates
corotates112714283corotates
correlates1248673correlates
creates95225203_cre_ates
cremates124216003_cremates
depredates1445503depredates
federates13310153federates
ferrates113013423fer_rates
firebases1446583firebases
firedamps1742843firedamps
firedrakes1843123firedrakes
firewater1545213firewater
firewaters1644323firewaters
floreated1346573flore_ated
fluoridates1573933fluoridates
folates103218453fo__lates
foliates11412753fo_liates
forages114217283for__ages
fordoes11311963for_d_oes
forearms1336603fore_arms
forebays1637263foreba_ys
forebodes1547613forebodes
forecasted1685103forecasted
forecaster1586003forecaster
forecasters1675003forecasters
forecastles1652183forecastles
forecasts1445803forecasts
foredating1577123foredating
foredecks1973383foredecks
foredone1249733foredone_
foredooms1544793foredooms
foreface1647113foreface_
forefather1943573forefather
forefathers2053143forefathers
foregather1743663foregather
foregathers1843223foregathers
foregoes1239523fore_goes
foreguts1245563foregut_s
forehands1656743forehands
foreladies1444983foreladies
forelands1347173forelands
foremasts1445793foremasts
forename1347853forename_
forenamed1545163forenamed
foreparts1445223foreparts
forepaws1695753forepa_ws
foreranks1645293foreranks
foresails1247153foresails
foresees11311643fore_sees
foresides1339703foresides
forestages1446733forestages
forestays1546623forestays
forested12312463fore_sted
forester11313673fore_ster
foresters12312533fore_sters
forests104114953fore_st_s
foretaste1295863foretaste_
foretasted1484753foretasted
foretimes1447453foretimes
forewarns1585633forewarns
foreyards1645503foreyards
formate123115093for_mate_
formats123113573for_mat_s
formulates1546543formulates
fornicates1545843fornicates
forsakes1536893for_sakes
fortes95327183for___tes
fortunates1345263fortunates
fouettes1137883foue_ttes
foveate1338363fove_ate_
foveated1536293fove_ated
frigates12310933f_rigates
furcates1339883fur_cates
gradates10510783_gradates
iodates8312903io__dates
loricates11310123loricates
moderates12710753moderates
oleates7417833_ole_ates
operates10515413_operates
orates64328613_or__ates
outdates93114743_outdates
oxidates1636333_oxidates
postdates1248863postdates
predate10616893_predate_
predated12513273_predated
prelates10418573_prelates
rebates95123183__rebates
redate74124683__redate_
redated93120923__redated
relates73731433__relates
remates93827113__remates
sedates83418043__sedates
sorbates10311103sor_bates
sororates9410473sororates
tolerates9312123tolerates
wordages1337053wor_dages
workmates1845003workmates
yokemates1844193yokemates

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411226.29623608.8
3Display Results1221220.0602033.3
 (SQL Overall)1786911226.76226425.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.