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

91 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
forename134785(None) 
forenamed1545161forenamed
forenames1447541forenames
filename1344352filename
foredate12310912foredate
foreface1647112foreface
foretime1348212foretime
prename11412642_prename
rename82718812__rename
aforetime1444043aforetime
bename103316073__bename
boresome1248403boresome
corelate10516013corelate
coronae94214893corona_e
coronate103018213coronate
cozenage2094793cozenage
crenate93317113_crenate
filenames1444293filenames
firebase1346493firebase
firedamp1643743firedamp
florence1347063floren_ce
forage104617003for__age
foram105124933for__am_
foramen12310533for__amen
forams115115913for__ams
forbade13259103for_bade
forbare122310513for_bare
forearm1238703fore_arm
forearmed1544863forearmed
forearms1336603forearms
forebay1538133foreba_y
forebays1637263forebays
forebode1448273forebode
forebye1536353fore_bye
forecast1349763forecast
foredated1447683foredated
foredates13310053foredates
foredone1249733foredone
forefaces1747133forefaces
foregone1238583foregone
forehand1537693forehand
forelady1545073forelady
foreland1239013foreland
forelimb1544083forelimb
foreman12312363forema_n
foremast1348613foremast
foremen12412923fore__men
forenoon1146823forenoon
forensic1344943forensic
forepart1349703forepart
forepast1348043forepast
forepaw1595613forepa_w
forepaws1695753forepaws
foreran10311793forera_n
forerank1546753forerank
foresaid1247803foresaid
foresail1147823foresail
foresaw1377133foresa_w
foresee10414333fore_see
foreside12310303foreside
forespake18105233forespake
forestage1346973forestage
foretaste1295863foretaste
foretimes1447463foretimes
forewarn14117173forewarn
forewomen1746463forewomen
foreyard1546423foreyard
forgave1435853for_gave
formate123115093for_mate
forme105225993for___me
forsake1436533for_sake
fortunate1245453fortunate
foveae1237563fove_a_e
foveate1338363fove_ate
frame105821803f_r__ame
frena85915273f_rena__
frenum1188803f_renum_
frenums1236203f_renums
furnace1235943fur_nace
grenade938413_grenade
jobname1842933jo_bname
novenae1046323novena_e
ornate6315143_or_nate
pregame1239553_pregame
prenames12311643_prenames
renamed103114523__renamed
renames92418053__renames
serenade9218343serenade
serenate81914883serenate
surname937603sur_name
username1042583username

Search took 9 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 Limit146162917.87618557.9
3Display Results91910.0332757.6
 (SQL Overall)178691918.32921454.1
 
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.