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

173 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
beauish1226851(None) 
beamish14259291beamish
bearish123013271bearish
banish111416042b_anish
beaus75127112beau_s_
beauts86015282beauts_
bleakish1745052bleakish
bluish1159242b_luish
boarish123911912boarish
deafish1438532deafish
peakish16268872peakish
weakish17217172weakish
wearish132310152wearish
aguish1059283_aguish
anguish11117633anguish
apish105116633__apish
baalism11310593baalism
babyish1736513babyish
baith108023133b_a_ith
baldish1339503baldish
bash915240163b_a__sh
basis75429863b_asis_
batfish1558683batfish
bauds85821043b_auds_
beach124623893bea__ch
beadier103513913beadier
beadiest113815533beadiest
beadily1378843beadily
beading113221863beading
beads85429503bea_ds_
beakier134012163beakier
beakiest143313463beakiest
beaks115326623bea_ks_
beamier113411943beamier
beamiest123212763beamiest
beamily1477393beamily
beaming123618803beaming
beamishly1973343beamishly
beams95328173bea_ms_
beanie83618593beani_e
beanies93821093beanies
beaning103820683beaning
beanos85516513beanos_
beans75734693bea_ns_
beards94116673beards_
bearing103624773bearing
bearishly1774293bearishly
bears75739043bea_rs_
beast76338643bea__st
beasts84519723beasts_
beatify1536593beatify
beating104326873beating
beats76042243bea_ts_
beau66137273beau___
beaut75135213beau__t
beauties10229523beauties
beautify1643183beautify
beauty115410163beau_ty
beaux146513213beau__x
because1136233becau_se
becurse1136183becurse
becurst1147853becurst
bedaubs1233693bedaubs_
beduin939713bedui_n
beduins1039123beduins
beguile1056933beguile
beguine1068503beguine
begums11429493begums_
bekiss1236373be_kiss
belauds1036643belauds_
bemist105216963be_mist
bemuse1038943bemu_se
bennis84314803bennis_
bequest1837823bequest
betise85616273be_tise
bialis83617163bialis_
biggish14247503biggish
blackish1976713blackish
blandish1497003blandish
blemish1436603blemish
blueish1236483blueish
blush105115313b_lu_sh
boarfish1635753boarfish
boggish14238653boggish
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233b_oyish
brackish1987613brackish
brainish1338813brainish
braise84318753bra_ise
brandish1469023brandish
brash106221563bra__sh
brassish1346433brassish
brattish1346973brattish
brinish1239963brinish
broadish1446933broadish
broguish1444103broguish
bruise83412873b_ruise
brush105917473b_ru_sh
brutish1237703brutish
buckish18237883buckish
bullish12511193bullish
burnish1238623burnish
bush96630713b__u_sh
cheapish1844333cheapish
clayish1547943clayish
cuish10313173__cuish
danish101513793_danish
dealfish1545503dealfish
deash95617243dea__sh
delish105215613de_lish
dervish1436983dervish
elfish1267963_elfish
elvish1277563_elvish
etuis54013133_etuis_
evanish1337653evanish
famish14311843_famish
fetish12310373fe_tish
fluish1239333_fluish
freakish1845543freakish
garish104516923_garish
goatish1139563goatish
grayish1437813grayish
headfish1845443headfish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
jadish17319903_jadish
jewfish2343543jewfish
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
radish103516913_radish
rakish134313963_rakish
ravish123414033_ravish
rawish123012913_rawish
realise73021813realise
realism93115923realism
realist73225383realist
reddish1238033reddish
redfish1437793redfish
relish93916953re_lish
revuist1038473revuist
roguish1156833roguish
selfish1388513selfish
serfish1348973serfish
slavish1338233slavish
squish1838573_squish
tenuis64213083tenuis_
toadish1139063toadish
vanish121513213_vanish
voguish1465203voguish
weakfish2143523weakfish
wennish1336243wennish
wettish1335963wettish

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.470380193.6
2DLD Change Limit1340271736.14021828.5
3Display Results1731730.0632746.0
 (SQL Overall)1786911736.67326778.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.