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

210 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
forbear123752(None) 
forbears1337071forbears
forebear1346381forebear
forbad122710502forb_ad
forbare122310512forb_are
forbearer1444512forbearer
forcer114917342force_r
forearm1238702for_earm
forebay1538132forebay
forebears1446412forebears
forger104820772forge_r
forker134717902forke_r
former114221402forme_r
forswear1443292forswear
antbear935063antbear
arrear6310253_arrear
barber104419323barbe_r
bear66844643___bear
bobber95016743bobbe_r
bogbean1244643bogbean
bomber125014653bombe_r
border94419973borde_r
boreal84817213bor_eal
boreas85421733bor_eas
borer75131273bor_e_r
bugbear1233953bugbear
cobber124116843cobbe_r
comber125118503combe_r
corban10314693corb_an
corbeil11859213corbeil
corbel103715973corbe_l
corbels113813593corbels
corder94322883corde_r
corer75538873cor_e_r
corker124720853corke_r
cornea84018923cornea_
corneal94414503corneal
corneas94717003corneas
corner84625623corne_r
cudbear1233333cudbear
curber104517053curbe_r
darbar959953darb_ar
dobber114015423dobbe_r
dogear838193do_gear
dormer94415903dorme_r
dorper94314573dorpe_r
dorser74819183dorse_r
drear65016903_dr_ear
durbar968723durb_ar
fabber134814113fabbe_r
farcer115016083farce_r
farceur12525273farceur
farer86733143far_e_r
farmer115017373farme_r
fear75337793f___ear
ferbam1339003ferb_am
fibber134811933fibbe_r
fiber104921133f_ibe_r
firearm1237203fir_earm
firer811229253fir_e_r
firmer114712443firme_r
foamer114714313foame_r
fobbed144112613fobbe_d
fodder114712113fodde_r
fogger114414783fogge_r
folder104317543folde_r
foliar93210973fo_liar
fonder104120063fonde_r
footer94320773foote_r
footgear12113063footgear
footwear14103373footwear
fora75937393for__a_
forager114412563forager
foram105124933for__am
foray115023973for__ay
forayer13368953forayer
forb97131333forb___
forbade13259103forbade
forbearers1543673forbearers
forbearing1644803forbearing
forbid123312433forb_id
forbidal1444833forbidal
forbids13268263forbids
forbode13257963forbode
forbore12249673forbore
forbs105720803forb__s
forby135317673forb__y
forbye14427883forb_ye
force105324273force__
forced126316523force_d
forceps14466983forceps
forcers124215713forcers
forces114422133force_s
forded115020393forde_d
fore78351473for_e__
forearms1336603for_earms
forebays1637263forebays
foreby1438633for_eby
forebye1536353forebye
foredo10510823for_edo
forego1038903for_ego
forehead1537893forehead
foreman12312363foreman
forepart1349703forepart
forepaw1595613forepaw
forepeak17134783forepeak
foreran10311793foreran
fores85847103for_e_s
foresaw1377133foresaw
foreseer1139013foreseer
forest94926743for_est
foreswear1543513foreswear
forever1338953forever
forewarn14117173forewarn
foreyard1546423foreyard
forfeit1339203forfeit
forfend1435413forfend
forgat104018583for_gat
forge95126943forge__
forged115519323forge_d
forgers115218183forgers
forgery14419303forgery
forges105024263forge_s
forget106326393forge_t
forgets113813793forgets
forgoer1137693forgoer
forked145217143forke_d
forkers144615783forkers
forkier144311593forkier
formal113215203for_mal
format113021353for_mat
forme105225993forme__
formed125021173forme_d
formee113919943forme_e
formers128217953formers
formes114623713forme_s
fornent10312933fornent
forswears1543243forswears
forte86131463forte__
fortes95327183forte_s
forward1438293for_ward
forwent13310533forwent
foster94322223foste_r
fouler93614903foule_r
fovea11310483fo_vea_
foveae1237563fo_veae
foveal1237703fo_veal
foveas1238623fo_veas
fowler123712583fowle_r
foxier163910033foxie_r
foyer116416553fo_ye_r
fozier183710663fozie_r
freak125115243f_r_eak
freer86021243f_r_eer
friar85414273f_r_iar
frier85225843f_rie_r
fryer115913433f_rye_r
fubar1039923f_ub_ar
furbearer1443033furbearer
furler93616403furle_r
gerbera1034773gerbera
goober93911743goobe_r
gorger86116983gorge_r
gorier73719373gorie_r
hobber134114633hobbe_r
hornbeam1543593hornbeam
horsecar1344513horsecar
jobber173813353jobbe_r
lobar7313013lo_b_ar
lobber104016603lobbe_r
loreal63814313lor_eal
mobber123613463mobbe_r
morceau1145573morceau
mortar83812043mor_tar
morular978223morular
obeah1038993_o_beah
offbeat1564143offbeat
omber95316443_ombe_r
orbed85516193_orbe_d
orbier839993_orbier
ordeal779253_ordeal
order65019363_orde_r
oread64619603_or_ead
orgeat7515033_orgeat
ormer75218373_orme_r
overbear13228883overbear
porker124917543porke_r
porter84224413porte_r
prober104516073probe_r
rear45644553__r_ear
rebar75420193__rebar
robber103916533robbe_r
sobber104016593sobbe_r
sober74822413so_be_r
somber103714003sombe_r
sorbed94916523sorbe_d
sorbent92915243sorbent
sorbet83924083sorbe_t
sorbets93012513sorbets
sorer56236593sor_e_r
sorner64720393sorne_r
sorter64425093sorte_r
soybean1243953soybean
unbear889163_unbear
upbear1096493_upbear
uprear8168793upr_ear
worker134715113worke_r
wormer114514913worme_r
wormgear1441883wormgear
worser95117523worse_r

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.410435831.7
2DLD Change Limit1340272105.89022755.0
3Display Results2102100.0762763.2
 (SQL Overall)1786912106.37628025.6
 
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.