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

290 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
boarish12391191(None) 
bearish123013271bearish
boarfish1635751boarfish
boorish123712591boorish
banish111416042b_anish
beamish14259292beamish
beauish12268512beauish
boards94616932boards_
boars75229602boar_s_
boarts84716872boarts_
boggish14238652boggish
boobish14338942boobish
bookish163610022bookish
boxfish2285542boxfish
boyarism1546392boyarism
boyish142911232bo_yish
broadish1446932broadish
garish104516922_garish
goatish1139562goatish
marish114319052_marish
moorish123311782moorish
noirish1037882noirish
nourish1039702nourish
oafish121311722_oafish
oarfish13158612_oarfish
ogrish1039262_ogrish
parish115022352_parish
poorish123712302poorish
sourish10310692sourish
toadish1139062toadish
tovarish1445122tovarish
wearish132310152wearish
abolish12311503abo_lish
aorist64827873ao_rist
apish105116633__apish
arise56436433__arise
baalism11310593baalism
babyish1736513babyish
bairnish1345473bairnish
baith108023133b_a_ith
baldish1339503baldish
barbs95928193b_arbs_
bards87139643b_ards_
bares75457133b_ares_
barest85327693b_arest
barfs104826003b_arfs_
baric96125693b_ari_c
baring95135853b_aring
barista9310813b_arista
barite84224813b_arite
barium10313513b_arium
barks115735813b_arks_
barms96128463b_arms_
barns76335143b_arns_
bars66564093b_ar_s_
bash915240163b_a__sh
basis75429863b_asis_
batfish1558683batfish
beards94116673beards_
bearing103624773bearing
bearishly1774293bearishly
bears75739043bear_s_
bialis83617163bialis_
biggish14247503biggish
binarism1248353binarism
blackish1976713blackish
blandish1497003blandish
blares85021633blares_
blaring104317113blaring
bleakish1745053bleakish
blemish1436603blemish
blockish19115793blockish
blondish1476173blondish
blowfish1944703blowfish
blueish1236483blueish
bluish1159243b_luish
boar66134293boar___
board85523003boar__d
boarded113910503boarded
boarder103910323boarder
boarding123110233boarding
boarfishes1844973boarfishes
boart78835933boar__t
boas66150833boa__s_
boast75935703boa__st
boasts85017923boasts_
boating103721303boating
boats75635153boa_ts_
boccis123911133boccis_
bogarts1047743bogarts_
bogyism1545213bogyism
bohrium1475013bohrium
bonacis11310323bonacis_
bonefish1646283bonefish
boorishly1743633boorishly
boors74325013boor_s_
borals86721913borals_
boras75938303bo_ras_
bores76448253bo_res_
boric98024223bo_ri_c
boride9415903bo_ride
boring94724873bo_ring
borks115727703bo_rks_
borsch1336133bo_rsch
borsht11813503bo_r_sht
borts76735453bo_rts_
bosh96328973bo___sh
bossism1136063bossism
botanise1039643botanise
botanist10412033botanist
bourgs9459993bourgs_
bourns84114063bourns_
bourse84414333bour_se
boursin938283boursin
boyards13399323boyards_
boyarisms1645443boyarisms
boyars115611983boyar_s_
brackish1987613brackish
brainish1338813brainish
braise84318753bra_ise
brandish1469023brandish
brash106221563b__rash
brassish1346433brassish
brattish1346973brattish
brinish1239963brinish
bris65539613b__ris_
brisk115615983b__risk
briss75824273b__riss
brith104924373b__rith
broguish1444103broguish
brownish1645643brownish
brush105917473b__rush
brutish1237703brutish
buckish18237883buckish
bullish12511193bullish
bulrush1243593bulrush
burnish1238623burnish
carlish12312763_carlish
charism14712203charism
cherish15310463cherish
clayish1547943clayish
coalfish1635493coalfish
coarse84813893coar_se
coatis85122593coatis_
cockish1838503cockish
codfish1637163codfish
coldish1399303coldish
coltish121310933coltish
coolish12312523coolish
cowfish1836433cowfish
coyish143710393co_yish
currish1238353currish
czarism2056423czarism
czarist18710223czarist
danish101513793_danish
darkish1537943_darkish
deafish1438533deafish
diarist8517113diarist
dogfish15226763dogfish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dovish1338103do_vish
dwarfish1843783dwarfish
evanish1337653evanish
fairish1338993fairish
famish14311843_famish
flourish1446753flourish
fogyish1735363fogyish
folkish1736563folkish
foolish1339613foolish
foppish1735103foppish
foxfish2354483foxfish
garfish14179203_garfish
garnish111610843_garnish
goatfish1544293goatfish
goodish1237963goodish
goyish13379013go_yish
grayish1437813grayish
harsh116418053_har_sh
hoards104912623hoards_
hoarier104211743hoarier
hoariest11312883hoariest
hoarily1338973hoarily
hoars85925543hoar_s_
hoarse94411323hoar_se
hogfish17257023hogfish
hoggish15247593hoggish
hottish13117893hottish
houris94514563houris_
jadish17319903_jadish
knavish1743993knavish
largish1138603_largish
laris54737463_laris_
larkish1439083_larkish
latish92416173_latish
lavish124112983_lavish
loggish12258723loggish
longish11229093longish
loris55329153lo_ris_
loudish1137983loudish
loutish1039963loutish
lowish12310533lo_wish
marsh105320853_mar_sh
mobbish1635923mobbish
modish123813543mo_dish
monish114217593mo_nish
monkish1638243monkish
moonish123311043moonish
mopish134311593mo_pish
morris83814723morris_
naris55735293_naris_
noris54928273no_ris_
oaring74225303_oaring
oars46846033_oar_s_
oasis56422553_oasis_
oddish11107653_oddish
offish15137273_offish
ogreish1134673_ogreish
ogrism937913_ogrism
oldish10169313_oldish
onrush935343_onrush
orisha936773_o_risha
orris54516553_orris_
owlish1238693_owlish
palish114718273_palish
pariah114320583_pariah
paris75145943_paris_
peakish16268873peakish
perish114619063_perish
planish12412053planish
polarise10513903polarise
polish114916723po_lish
pooris83916843pooris_
popish133812113po_pish
porism104518063po_rism
radish103516913_radish
rakish134313963_rakish
ravish123414033_ravish
rawish123012913_rawish
roaring82916003roaring
roars55622233roar_s_
roguish1156833roguish
rompish1436693rompish
saris54544953_saris_
shariah132210533shariah
slavish1338233slavish
soaring83521893soaring
soars54732513soar_s_
softish13127813softish
solarise8512543solarise
solarism10810383solarism
sottish10129433sottish
souaris7312323souaris_
sparkish17276973sparkish
squarish2047323squarish
starfish1438083starfish
tarnish101611873_tarnish
tartish101512633_tartish
tigrish1137563tigrish
toadfish1544903toadfish
toadyish1544153toadyish
tonish93415903to_nish
tonnish10149093tonnish
tourism939423tourism
tourist7313203tourist
tovarich1643453tovarich
townish13167933townish
toyish122911123to_yish
tsarism958253tsarism
tsarist7712253tsarist
tzarism1866323tzarism
tzarist1659103tzarist
uraris63817273uraris_
vanish121513203_vanish
varnish13169533_varnish
voguish1465203voguish
votarist111012163votarist
warmish1538373_warmish
weakish17217173weakish
whorish1636603whorish
woggish15276673woggish
wolfish1636933wolfish
womanish1646823womanish
wormish1537163wormish
zoaria1548373zoari_a
zoarial1646923zoarial
zoarium1846093zoarium
zoris145320013zo_ris_

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.1561145455.1
2DLD Change Limit1340272907.58017681.7
3Display Results2902900.1102636.4
 (SQL Overall)1786912907.84622774.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.