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

197 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
forbade1325910(None) 
forbad122710501forbad_
forbare122310511forbare
forbode13257961forbode
corrade101111042corrade
forage104617002for_age
forbid123312432forbid_
forbids13268262forbids
forboded15215352forboded
forbodes14217102forbodes
forbore12249672forbore
forbye14427882forb_ye
forebode1448272forebode
forgave1435852forgave
formate123115092formate
forrader1236152forrader
forsake1436532forsake
sorbate9311732sorbate
torsade837592torsade
abrade9313053abr_ade
aortae65115473aorta_e
arcade91013643_arcade
aubade939223_aubade
bade75140893___bade
barbate11314543barbate
borage93917013bor_age
borane84620213bor_ane
borate85026153bor_ate
boride9415903bor_ide
brocade1238533brocade
carbide126112493carbide
cockade1638133cockade
comade114415323co_made
comrade12139213comrade
corban10314693corba_n
corbans11313173corbans
corbie103618203corb_ie
cordage11310063cordage
cordate10315223cordate
corkage1438373corkage
corraded12128293corraded
corrades111211263corrades
corrode101310573corrode
corsage1039803corsage
couvade1335063couvade
cowbane1437673cowbane
dogbane1135653dogbane
dorado838813dor_ado
dorsad8408973dorsad_
facade1238803f_acade
fade85736353f___ade
farad95720683far_ad_
farads104713273far_ads
farside1138603farside
ferbam1339003ferba_m
ferbams1435743ferbams
feriae95618603feria_e
fermate122813003fermate
ferrate103014043ferrate
firebase1346493firebase
florae94713883flor_a_e
fobbed144112613fobbed_
foggage1334113foggage
foible11410383foib_le
folate93320393fo_late
foliage1147533foliage
foliate10513533foliate
footage1148843footage
fora75937393for_a__
foraged124812283for_aged
forager114412563for_ager
forages114217283for_ages
foram105124933for_a_m
foramen12310533for_amen
forams115115913for_ams
foray115023973for_a_y
forayed14368593for_ayed
forayer13368953for_ayer
forays124813003for_ays
forb97131333forb___
forbear1237523forbear
forbearer1444513forbearer
forbears1337073forbears
forbidal1444833forbidal
forbidden1642393forbidden
forbidder1642863forbidder
forborne13195003forborne
forbs105720803forb__s
forby135317673forb__y
force105324273for__ce
forced126316523forced_
ford86835493for__d_
fordable1439593fordable
forded115020393for__ded
fordid113512053fordid_
fordo97218653for__do
fordone1149383fordone
fords95328183for__ds
fore78351473for___e
forearm1238703forearm
forebay1538133foreba_y
forebays1637263forebays
foreboded1645673foreboded
foreboder1545743foreboder
forebodes1547613forebodes
forebody1745153forebody
forebye1536353forebye
foredate12310913foredate
foredo10510823for_edo
foreface1647113foreface
forelady1545073forelady
forename1347853forename
foresee10414333foresee
foreside12310303foreside
forgat104018583forga_t
forge95126943for__ge
forged115519323forged_
forgive1436193forgive
forgone1139343forgone
forjudge2041853forjudge
forkball1744823forkball
forked145217143forked_
formable1539503formable
formal113215213forma_l
formals123312893formals
formamide1744403formamide
formant123416003formant
format113021363forma_t
formates132814293formates
formats123113573formats
forme105225993for__me
formed125021173formed_
formee113919943for_mee
forrarder1343623forrarder
forsaken1543353forsaken
forsaker1545103forsaker
forsakes1536893forsakes
forte86131463for__te
fortune1068303fortune
forward1438293forward
forwarded1743943forwarded
forwarder1644133forwarder
forwards1537043forwards
forzandi2143043forzandi
forzando2142763forzando
fossae95510373fossa_e
fossate10388603fossate
foveae1237563fovea_e
foveate1338363foveate
frae75330473f_r_a_e
frame105821803f_r_ame
fromage1336753fromage
furane94015493fur_ane
furcate12310453furcate
furnace1235943furnace
gambade1336383gambade
garbage1138053garbage
grade75126093_gr_ade
herbage1337013herbage
horde94623053hor__de
irade65618153_ir_ade
lobate82915243lo_bate
morae75831193mor_a_e
morale85220553mor_ale
morbid112511463morbid_
normande1145943normande
noyade1036423no_yade
orad56031693_or_ad_
orate55133303_or_ate
orbed85516193_orbed_
oread64619603_oread_
oreads73915773_oreads
oreide7311673_oreide
ornate6315143_ornate
oroide7311703_oroide
parade94720643par_ade
parbake1538353parbake
parkade1437583parkade
pervade1337023pervade
pomade113611333po_made
portage103013643portage
prebade12310283prebade
probate11414483probate
roulade857003roulade
sorbable1239303sorbable
sorbates10311103sorbates
sorbed94916523sorbed_
sorbose938983sorbose
surbase939793surbase
tirade7311693tir_ade
tornado845673tornado
torsades937213torsades
trade65026043_tr_ade
tribade1037293tribade
urbane82211383_urbane
vorlage1136403vorlage
wordage1236503wordage

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.440406115.9
2DLD Change Limit1340271976.96619240.2
3Display Results1971970.0802462.5
 (SQL Overall)1786911977.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.