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

93 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
foreyard154642(None) 
foreyards1645501foreyards
boneyard1475322boneyard
farmyard1742832farmyard
forearm1238702fore_arm
forehand1537692forehand
foreland1239012foreland
forepart1349702forepart
foresaid1247802foresaid
forewarn14117172forewarn
foreword15118962foreword
forward1438292for_ward
aforehand1642813aforehand
aforesaid1343263aforesaid
barnyard1443783barnyard
beeyard1335523_beeyard
boatyard1444073boatyard
boneyards1584623boneyards
boyard125411283bo__yard
chresard1444063chresard
coalyard1444093coalyard
courtyard1542193courtyard
deeryard1353593deeryard
dockyard1943283dockyard
dooryard1343373dooryard
farmyards1842813farmyards
feedyard1642323feedyard
firearm1237203fire_arm
firebird1444633firebird
fireboard1546613fireboard
fireguard1442903fireguard
forayed14368593foray_ed
forayer13368953forayer_
forayers14277273forayers
forbad122710503for_ba_d
forbare122310513for_bare
forbear1237523forbear_
forbears1337073forbears
forearmed1544863fore_armed
forearms1336603fore_arms
forebay1538133foreba_y
forebays1637263forebays
forebear1346383forebear_
forebears1446413forebears
forecast1349763forecast
foredate12310913foredate
foredated1447683foredated
foredid1238503fore_did
foreface1647113foreface
forefend1545603forefend
forehands1656743forehands
forehead1537893forehead
forelady1545073forelady
forelands1347173forelands
foreman12312363forema_n
foremast1348613foremast
forename1347853forename
forenamed1545163forenamed
foreparts1445223foreparts
forepast1348043forepast
forepaw1595613forepa_w
forepaws1695753forepaws
foreran10311793forera_n
forerank1546753forerank
foresail1147823foresail
foresaw1377133foresa_w
forested12312463forested
forestry1446723forestry
foretold1256493foretold
forever1338953forever_
forevers1438173forevers
forewarned1743583forewarned
forewarns1585633forewarns
forewords16117403forewords
foreworn14108863foreworn
forwards1537043for_wards
foulard11257283fo_ulard
foureyed1543663fourey_ed
froward1436673f_roward
homeward1745333homeward
kaleyard1683573kaleyard
notecard1144113notecard
orchard1346933_orchard
oread64619603_ore_a_d
poleward1455943poleward
regard85215773__regard
rereward1246143rereward
retard75018933__retard
reward106017643__reward
reynard1135123__reynard
scorecard1442953scorecard
shoreward1644093shoreward
vineyard1543983vineyard

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.466383457.1
2DLD Change Limit146162937.89318517.9
3Display Results93930.0462021.7
 (SQL Overall)178691938.40521260.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.