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

155 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
forebay153813(None) 
forebays1637261forebays
foreby1438631foreb_y
foray115023972for__ay
forbad122710502for_bad
forbear1237522forbear
forby135317672for_b_y
forebear1346382forebear
forebody1745152forebody
forebye1536352forebye
forelady1545072forelady
foreman12312362foreman
forepaw1595612forepaw
foreplay1645672foreplay
foreran10311792foreran
foresaw1377132foresaw
forestay1448192forestay
rosebay12135772rosebay
boreal84817213bore_al
boreas85421733bore_as
corban10314693cor_ban
corby125018533cor_b_y
daresay1135433daresay
faraday1445633faraday
faraway1645413faraway
farebox1943823farebox
feebly1436653f_eebly
ferbam1339003fer_bam
fireback1946953fireback
fireball13127263fireball
firebase1346493firebase
fireboat1349093fireboat
firebox1944453firebox
firebrat1348143firebrat
firebug1383793firebug
fireclay1644183fireclay
firefly1635633firefly
fireman1249333fireman
firepan1236983firepan
foeman11311233fo_eman
foetal9311883fo_etal
fogey125617873foge__y
foley115222303fole__y
folkway2043353folkway
footbag1344553footbag
footboy1544913footboy
footway1635253footway
fora75937393for__a_
foram105124933for__am
forays124813003for__ays
forb97131333for_b__
forbade13259103for_bade
forbare122310513for_bare
forbears1337073forbears
forbid123312433for_bid
forbs105720803for_b_s
forbye14427883for_bye
forcedly1744793forcedly
forcibly1843863forcibly
fore78351473fore___
forearm1238693forearm
forebears1446413forebears
forebode1448273forebode
foreboom1546123foreboom
forebrain1445163forebrain
forecast1349763forecast
foredate12310913foredate
foredid1238503foredid
foredo10510823fore_do
foreface1647113foreface
forego1038903fore_go
foregut1149163foregut
forehand1537693forehand
forehead1537893forehead
foreign1136833foreign
foreland1239013foreland
foreleg1137743foreleg
foremast1348613foremast
foremen12412923foremen
forename1347853forename
forepart1349703forepart
forepast1348043forepast
forepaws1695753forepaws
forepeak17134783forepeak
foreplays1745043foreplays
forerank1546753forerank
forerun1037653forerun
fores85847103fore__s
foresaid1247803foresaid
foresail1147823foresail
foresee10414333foresee
forest94926743fore_st
forestal11410283forestal
forestays1546623forestays
forestry1446723forestry
forests104114953forests
foretop12117893foretop
forever1338953forever
forewarn14117163forewarn
foreyard1546423foreyard
forgat104018583for_gat
forgery14419303forgery
forkball1744823forkball
forkedly1944313forkedly
forky156119643for__ky
formably1846663formably
formal113215203for_mal
format113021353for_mat
formerly1645003formerly
fortify1636523fortify
forty114824273for__ty
forwhy1834423for_why
fovea11310483fove_a_
foveae1237563fove_ae
foveal1237703fove_al
foveas1238623fove_as
fray105428903f_r__ay
freak125115243f_re_ak
freaky16439233f_reaky
freely12310953f_reely
freeway1635603freeway
frena85915273f_rena_
frenzy2135883f_renzy
fretty1249223f_retty
goombay1543553goombay
hereby14468333hereb_y
homeboy1746153homeboy
loreal63814313lore_al
moray105423793mor__ay
nosebag1043673nosebag
nosegay1143843nosegay
orby97519603_or_b_y
oread64619603_ore_ad
orfray1234393_orfray
portray1237483portray
prebuy1357423_prebuy
prepay13310313_prepay
rebar75420193__rebar
rebuy104714683__rebuy
redbay1238333__redbay
relay84424673__relay
repay104818453__repay
resay85320543__resay
ropeway1544773ropeway
rosebays13114903rosebays
someday1345883someday
someway1545613someway
sorely94618013sore_ly
trebly1138973_trebly
virelay1335943virelay
wireway1646043wireway
workbag1742923workbag
workday1843303workday
zareba1736423zareba_
zarebas1836303zarebas

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271556.60620288.7
3Display Results1551550.0463369.6
 (SQL Overall)1786911556.80826247.2
 
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.