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

212 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
beamish1425929(None) 
bearish123013271bearish
beauish12268511beauish
banish111416042b_anish
beamier113411942beamier
beamiest123212762beamiest
beamily1477392beamily
beaming123618802beaming
beamishly1973342beamishly
beams95328172beam_s_
bemist105216962be_mist
bleakish1745052bleakish
blemish1436602blemish
boarish123911912boarish
deafish1438532deafish
famish14311842_famish
heimish1535462heimish
peakish16268872peakish
weakish17217172weakish
wearish132310152wearish
amis66445323__amis_
amiss75823073__amiss
apish105116633__apish
baalism11310593baalism
babyish1736513babyish
baith108023133b_a_ith
baldish1339503baldish
bams87044453b_am_s_
bash915240163b_a__sh
basis75429863b_asis_
batfish1558683batfish
beach124623893bea__ch
beadier103513913beadier
beadiest113815533beadiest
beadily1378843beadily
beading113221863beading
beads85429503bea_ds_
beakier134012163beakier
beakiest143313463beakiest
beaks115326623bea_ks_
beam86939233beam___
beamed115720733beam_ed
beamless12327003beamless
beamlike16115843beamlike
beamy126218573beam__y
beanie83618593beani_e
beanies93821093beanies
beaning103820683beaning
beanos85516513beanos_
beans75734693bea_ns_
beards94116673beards_
bearing103624773bearing
bearishly1774293bearishly
bears75739043bea_rs_
beast76338643bea__st
beasts84519723beasts_
beatify1536593beatify
beating104326873beating
beats76042243bea_ts_
beaus75127113bea_us_
beauts86015283beauts_
bedamns1235733bedamns_
bedims1149593bedims_
bekiss1236373be_kiss
bemas96424283be_mas_
bemire103312803be_mire
bemists113410703be_mists
bemix165011453be_mi_x
bemixt174510363be_mixt
bemuse1038943be_muse
benames112814603benames_
benaming1339693benaming
bennis84314803bennis_
bermes106023003bermes_
berming123614833berming
berms95323663berm_s_
besmile1137463besmile
besmirch1742133besmirch
betise85616273be_tise
bialis83617163bialis_
bigamist1347063bigamist
biggish14247503biggish
blackish1976713blackish
blames105121863blames_
blaming123515693blaming
blams95023853blam_s_
blandish1497003blandish
blimpish1743723blimpish
blueish1236483blueish
bluish1159243b_luish
boarfish1635753boarfish
boggish14238653boggish
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233b_oyish
brackish1987613brackish
brainish1338813brainish
braise84318753bra_ise
brandish1469023brandish
brash106221563bra__sh
brassish1346433brassish
brattish1346973brattish
breaming133612513breaming
breams104815043bream_s_
brinish1239963brinish
broadish1446933broadish
bromism1337623bromism
brutish1237703brutish
buckish18237883buckish
bullish12511193bullish
burnish1238623burnish
camisa103114323_camisa
camise103319633_camise
ceramist12310933ceramist
chamisa14328853chamisa
chamise143612853chamise
chamiso14348653chamiso
cheapish1844333cheapish
clayish1547943clayish
dampish1567663_dampish
danish101513793_danish
dealfish1545503dealfish
deash95617243dea__sh
degamis11268443degamis_
delish105215613de_lish
demise94618323de_mise
dermis94717163dermis_
dervish1436983dervish
elfish1267963_elfish
elvish1277563_elvish
enmesh1134893_enmesh
evanish1337653evanish
fermis114313503fermis_
fetish12310373fe_tish
flemish1536373flemish
freakish1845543freakish
garish104516923_garish
gnomish1345563gnomish
goatish1139563goatish
grayish1437813grayish
haimish1537753haimish
headfish1845443headfish
hellish13310723hellish
hennish1336863hennish
jadish17319903_jadish
jewfish2343543jewfish
kermis124012393kermis_
knavish1743993knavish
latish92416173_latish
lavish124112983_lavish
leash85519213lea__sh
leftish13197253leftish
marish114319053_marish
nebbish1444253nebbish
nerdish1137103nerdish
newish1237903ne_wish
oafish121311723_oafish
obeahism1542873obeahism
palish114718273_palish
parish115022353_parish
peckish18227293peckish
peevish1535783peevish
perish114619063pe_rish
perkish16258823perkish
pettish1238283pettish
planish12412053planish
qualmish2244013qualmish
quamash2144293quamash
radish103516913_radish
rakish134313963_rakish
rammish1437563rammish
ravish123414033_ravish
rawish123012913_rawish
realise73021813realise
realism93115923realism
realist73225383realist
reaming103924013reaming
reams75729623ream_s_
reddish1238033reddish
redfish1437793redfish
relish93916953re_lish
remise84221953re_mise
remiss84216353re_miss
scampish1744893scampish
seamier93114633seamier
seamiest102715423seamiest
seaming103222113seaming
seams75731663seam_s_
selfish1388513selfish
semis74623533se_mis_
serfish1348973serfish
slavish1338233slavish
squeamish2342653squeamish
swamis114212293swamis_
swampish1844173swampish
tamis76728733_tamis_
teaming103917593teaming
teams75726513team_s_
toadish1139063toadish
trampish1535653trampish
umamis1038273umamis_
vampish1766283_vampish
vanish121513213_vanish
vermis114214963vermis_
wampish1777293_wampish
warmish1538373warmish
weakfish2143523weakfish
wennish1336243wennish
wettish1335963wettish
wormish1537163wormish

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.393454684.5
2DLD Change Limit1340272125.98322401.3
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.45227695.4
 
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.