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

90 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
foreface164711(None) 
forefaces1747131forefaces
foredate12310912foredate
forename1347852forename
preface14510922_preface
reface113616352__reface
barefaced1743703barefaced
boldface1662893boldface
boniface1543863boniface
corelate10516013corelate
deface123113863__deface
dogface1454053do_gface
falseface1751543falseface
fireback1946953fireback
firebase1346493firebase
firefang1543923firefang
fireplace1644873fireplace
florence1347063flore_nce
footpace1544493footpace
footrace1346413footrace
forage104617003for__age
forbade13259103for_bade
forbare122310513for_bare
force105324273for___ce
forearm1238703fore_arm
forebay1538133foreba_y
forebays1637263forebays
forebode1448273forebode
forebye1536353fore_bye
forecast1349763forecast
foredated1447683foredated
foredates13310053foredates
foredeck1874353foredeck
foredone1249733foredone
forefather1943573forefather
forefeel14105513forefeel
forefeet14129393forefeet
forefelt14117363forefelt
forefend1545603forefend
forefoot1448153forefoot
foregone1238583foregone
forehand1537693forehand
forelady1545073forelady
foreland1239013foreland
forelock1745593forelock
foreman12312363forema_n
foremast1348613foremast
forenamed1545163forenamed
forenames1447543forenames
forepart1349703forepart
forepast1348043forepast
forepaw1595613forepa_w
forepaws1695753forepaws
foreran10311793forera_n
forerank1546753forerank
forereach1743663forereach
foresaid1247803foresaid
foresail1147823foresail
foresaw1377133foresa_w
foresee10414333fore_see
foreside12310303foreside
forespake18105233forespake
forestage1346973forestage
foretaste1295863foretaste
foretime1348213foretime
forewarn14117173forewarn
foreyard1546423foreyard
forgave1435853for_gave
formate123115093for_mate
forsake1436533for_sake
foveae1237563fove_a_e
foveate1338363fove_ate
fullface1642553fullface
furnace1235943fur_nace
horserace1445733horserace
orifice1246343_orifice
outface123011973_outface
paleface1545343paleface
postface1566123postface
prefaced1638423_prefaced
prefacer1537983_prefacer
prefaces15311063_prefaces
prefade1339013_prefade
prerace11414123_prerace
refaced133713573__refaced
refaces123216743__refaces
relace83122153__relace
surface1238653sur_face
typeface1842423typeface
workfare1843123workfare

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.423422437.4
2DLD Change Limit146162907.03020791.2
3Display Results90900.0332727.3
 (SQL Overall)178691907.48623870.0
 
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.