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

176 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
ferbams143574(None) 
ferbam1339001ferbam_
ferals94216642fer_als
ferias95020392feria_s
ferrums1265982ferrums
forams115115912for_ams
herbals122710612herbals
verbals121910742verbals
yerbas11119292yerba_s
aerials74017563aerials
aerobats1049853aerobats
airbags1036293airbags
bams87044453___bams
beams95328173be__ams
bedlams1237053bedlams
beldams1237053beldams
berms95323663ber__ms
breams104815053_breams
ceibas1038503ceiba_s
cereals9313173cereals
cerias83321983ceria_s
ceriums1139483ceriums
corbans11313173corbans
crams96229153_cr_ams
creams104715253_creams
darbars10510093darbars
debags104211063de_bags
debars94218043de_bars
defoams1336193defoams
derats74625063der_ats
derays105514253der_ays
derbies103016053derbies
dermas94116823derma_s
derms85022893der__ms
dirams94413703dir_ams
dirhams13376313dirhams
drams86025833_dr_ams
dreams94513983_dreams
durbars1077973durbars
embalms1335333_embalms
embars103812883_embars
embays131408333_embays
eras45441503_er_a_s
erbiums1135463_erbiums
exams14199083_e_xams
farads104713273far_ads
farfals13268503farfals
farms106324963far__ms
fears84829393fe__ars
feats86432753fe__ats
fecials123510333fecials
feebs106112683feeb__s
feedbags1592733feedbags
fellahs13428393fellahs
fellas95116963fella_s
fems96428703fe___ms
feral85424653fer_a_l
feres86038183fer__es
feria85922713feria__
feriae95618603feria_e
ferial94621253feria_l
ferlies103216693ferlies
fermata12278143fermata
fermatas13246223fermatas
fermate122813003fermate
fermi103914163fer__mi
fermis114313503fer_mis
fermiums1544353fermiums
ferns85220083fer__ns
ferrate103014043ferrate
ferrates113013423ferrates
ferrels10248623ferrels
ferrets103111393ferrets
ferries103521083ferries
ferrous1049803ferrous
ferrum1147453ferrum_
ferulas103110753ferulas
ferules103112723ferules
fervors1336233fervors
fetas85624403fe_ta_s
fetials103711743fetials
feuars938653fe_uars
firearms1335403firearms
firmans12238523firmans
firms105217423fir__ms
flams105125013f__lams
fleabags1442283fleabags
fleams115011943f_leams
foams105017953f__oams
foram105124933for_am_
forays124813003for_ays
forbad122710503forba_d
forbade13259103forbade
forbare122310513forbare
forbears1337073forbears
forbids13268263forbids
forbs105720803forb__s
forearms1336603forearms
forebays1637263forebays
formals123312893formals
formats123113573formats
forms105327053for__ms
forums114611843for_ums
frags96322173f_r_ags
frame105821803f_r_ame
frames115119863f_r_ames
fraps105620553f_r_aps
frass85321123f_r_ass
frats86829673f_r_ats
frays116920103f_r_ays
freaks134713063f_reaks
frenums1236203frenums
friars93812093f_riars
fulhams1543983fulhams
fullams1236553fullams
furans94515953fur_ans
gerahs1039413ger_ahs
gerbils1037303gerbils
germans1079473germans
germs85118873ger__ms
grams85327313_gr_ams
herbage1337013herbage
herbages1437103herbages
herbal112513493herba_l
herbs105520503herb__s
herms105626433her__ms
ihrams1137173ihr_ams
jerboas1636163jerboas
jeroboams2052473jeroboams
jetsams16124103jetsams
jorams154810533jor_ams
kebabs14418513ke_babs
kebars124112493ke_bars
kerbs115013673kerb__s
marrams11310123marrams
perhaps1446123perhaps
perms95524513per__ms
praams10459643_praams
prams96125513_pr_ams
rams65950773__r_ams
reams75729623__reams
rebars84019833re_bars
redbays1336013redbays
redreams1195953redreams
rereads81512293rereads
reteams9339563reteams
roams74919613__roams
scrams105216623scr_ams
screams114810623screams
seabags1037483seabags
seams75731663se__ams
sebums10369813se_bums
seracs84418573ser_acs
serais64326133ser_ais
serdabs1035323serdabs
serials73919753serials
serums83916303ser_ums
servals103410753servals
streams94713373streams
teams75726513te__ams
terais64023513ter_ais
terbias9310743terbias
terbiums1245423terbiums
terms75523473ter__ms
terras63516973terra_s
trams75327673_tr_ams
turbans939563turbans
verbal112513663verba_l
verbids13259203verbids
verbs104614393verb__s
verisms123011253verisms
webcams1643073webcams
yerba101010763yerba__
zebras1737853zebra_s
zebrass1834113zebrass
zirams17438643zir_ams

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.423422437.4
2DLD Change Limit1340271766.57620381.2
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.06225303.2
 
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.