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 “forepaw” 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
forepaw159561(None) 
forepaws1695751forepaws
foresaw1377131foresaw
firepan1236982firepan
forebay1538132forebay
foreman12312362foreman
forepart1349702forepart
forepast1348042forepast
forepeak17134782forepeak
foreplay1645672foreplay
foreran10311792foreran
arepa75615563_arepa_
arepas85515703_arepas
boreal84817213bore_al
boreas85421733bore_as
fireman1249333fireman
firepans1347153firepans
firepot1248733firepot
foeman11311233fo_eman
foetal9311883fo_etal
footpad1343903footpad
fora75937393for__a_
foram105124933for__am
foray115023973for__ay
forbad122710503for_bad
forbear1237523forbear
forceps14466983forcep_s
fore78351473fore___
forearm1238703forearm
forebays1637263forebays
forebear1346383forebear
foreby1438633fore_by
forebye1536353forebye
forecast1349763forecast
foredate12310913foredate
foredid1238503foredid
foredo10510823fore_do
foreface1647113foreface
forego1038903fore_go
foregut1149163foregut
forehand1537693forehand
forehead1537893forehead
foreign1136833foreign
foreknew1843733foreknew
foreknow1842763foreknow
forelady1545073forelady
foreland1239013foreland
foreleg1137743foreleg
foremast1348613foremast
foremen12412923foremen
forename1347853forename
foreparts1445223foreparts
forepeaks18104573forepeaks
foreplays1745043foreplays
forerank1546753forerank
forerun1037653forerun
fores85847103fore__s
foresaid1247803foresaid
foresail1147823foresail
foresee10414333foresee
foreshow1785893foreshow
forespake18105233forespake
forespeak1843473forespeak
forest94926743fore_st
forestal11410283forestal
forestay1448193forestay
forests104114953forests
foretop12117893foretop
forever1338953forever
forewarn14117173forewarn
foreyard1546423foreyard
forgat104018583for_gat
formal113215203for_mal
format113021353for_mat
fovea11310483fove_a_
foveae1237563fove_ae
foveal1237703fove_al
foveas1238623fove_as
freak125115243f_re_ak
frena85915273f_rena_
fretsaw1343923f_retsaw
frypan1434543f_rypan
loreal63814313lore_al
notepad1044123notepad
oread64619603_ore_ad
prelaw1139103_prelaw
prepay13310313_prepay
repay104818453__repay
resaw84117253__resaw
scorepad1363383scorepad
trepan82511673_trepan

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 Filter1786911340270.410435831.7
2DLD Change Limit134027916.93619323.4
3Display Results91910.0303033.3
 (SQL Overall)178691917.37624226.0
 
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.