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

125 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
forebye153635(None) 
forbye14427881for_bye
foreby1438631foreby_
forby135317672for_by_
forebay1538132forebay
forebays1637262forebays
forebode1448272forebode
foresee10414332foresee
corbie103618203cor_bie
corby125018533cor_by_
debye1138903__debye
farebox1943823farebox
feeble1138253f_eeble
fireable131710223fireable
firebase1346493firebase
firebox1944453firebox
firebug1383793firebug
florence1347063florence
fogey125617873foge_y_
fogeys13509263foge_ys
foible11410383fo_ible
foley115222303fole_y_
foleys123810463fole_ys
forage104617003for_age
foray115023973for_ay_
forayed14368593for_ayed
forayer13368953for_ayer
forays124813003for_ays
forb97131333for_b__
forbad122710503for_bad
forbade13259103forbade
forbare122310513forbare
forbear1237523forbear
forbid123312433for_bid
forbode13257963forbode
forbore12249673forbore
forbs105720803for_b_s
force105324273for__ce
forceable1646213forceable
forcible1545143forcible
fordable1439593fordable
fordone1149383fordone
fore78351473for___e
forearm1238693forearm
forebear1346383forebear
foreboded1645673foreboded
foreboder1545743foreboder
forebodes1547613forebodes
forebody1745153forebody
foreboom1546123foreboom
foredate12310913foredate
foredid1238503foredid
foredo10510823fore_do
foredoes12310803foredoes
foredone1249733foredone
foreface1647113foreface
forefeel14105513forefeel
forefeet14129393forefeet
forego1038903fore_go
foregoer1237253foregoer
foregoes1239523foregoes
foregone1238583foregone
foregut1149163foregut
foreign1136833foreign
foreknew1843733foreknew
foreleg1137743foreleg
foreman12312363foreman
foremen12412923foremen
forename1347853forename
forepaw1595613forepaw
foreran10311793foreran
forerun1037653forerun
fores85847103fore__s
foresaw1377133foresaw
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
foreside12310303foreside
forest94926743fore_st
forested12312463forested
forester11313673forester
forests104114953forests
foretime1348213foretime
foretop12117893foretop
forever1338953forever
forgave1435853forgave
forge95126943for__ge
forgeable1545403forgeable
forgery14419303forgery_
forgive1436193forgive
forgone1139343forgone
forky156119643for_ky_
formable1539503formable
formate123115093formate
forme105225993for__me
formee113919943for_mee
formyl14276443for_myl
forsake1436533forsake
forte86131463for__te
fortune1068303fortune
forty114824273for_ty_
forwhy1834423forwhy_
fouette1038213fouette
foureyed1543663foure_yed
foveae1237563fove_ae
foveate1338363foveate
foveole13106873foveole
free75940183f_re__e
freebee1238043freebee
freebie1236043freebie
freeze18349513f_reeze
frere85617723f_re_re
frogeye1443813frogeye
goodbye14364193goodbye
grebe85114943_greb_e
hereby14468333hereby_
morelle91210803morelle
orby97519603_or_by_
oreide7311673_oreide
outbye1147913_outbye
oxeye1536913_oxe_ye
rebbe9313163__rebbe
redye94413463__redye
sorely94618013sorely_
treble8311663_treble

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.1561145455.1
2DLD Change Limit1340271257.33018284.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.53223724.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.