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

205 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
oarfish1315861(None) 
boarfish1635751boarfish
garfish14179201garfish
oafish121311721oa_fish
batfish1558682batfish
boarish123911912boar_ish
carlish12312762carlish
catfish1559022catfish
coalfish1635492coalfish
darkish1537942darkish
dwarfish1843782dwarfish
garish104516922gar_ish
garnish111610842garnish
goatfish1544292goatfish
hagfish17227612hagfish
largish1138602largish
larkish1439082larkish
marish114319052mar_ish
oarfishes15156952oarfishes
offish15137272o_ffish
ogreish1134672ogreish
ogrish1039262ogr_ish
outfish132210572outfish
overfish1737892overfish
panfish15229972panfish
parish115022352par_ish
raffish1658842raffish
ratfish1338772ratfish
sawfish1637682sawfish
serfish1348972serfish
starfish1438082starfish
tarnish101611872tarnish
tartish101512632tartish
toadfish1544902toadfish
varnish13169532varnish
waifish1637702waifish
warmish1538372warmish
afresh1255503_afresh
aguish1059283_aguish
aorist64827873aor_ist
apish105116633_a_pish
arfs76029963_arf_s_
arise56436433_ar_ise
arris56824683_arris_
arsis55722423_arsis_
artist64125543_artist
aspish114810333_aspish
babyish1736513babyish
bairnish1345473bairnish
baitfish1645483baitfish
baldish1339503baldish
banish111416043ba_nish
barfing134615093barfing
barfs104826003barf_s_
bearish123013273bear_ish
boarfishes1844973boarfishes
bonefish1646283bonefish
boorish123712593boor_ish
boxfish2285543boxfish
burnish1238623burnish
caddish143810123caddish
carwash1535993carwash
cattish12410723cattish
cavefish1974853cavefish
codfish1637163codfish
cowfish1836433cowfish
crawfish1944233crawfish
crayfish1944253crayfish
currish1238353currish
dampish1567663dampish
danish101513793da_nish
deafish1438533deafish
dealfish1545503dealfish
dervish1436983dervish
dogfish15226763dogfish
draffish1844553draffish
dryish1336323_dryish
dwarfism1742293dwarfism
elfish1267963_elfish
faddish15359003faddish
fairish1338993fairish
fallfish1744463fallfish
famish14311843fa_mish
fattish1359263fattish
finfish16268193finfish
fish106926273___fish
flatfish1744933flatfish
foolfish1744393foolfish
foxfish2354483foxfish
furbish1536443furbish
furnish1337383furnish
garfishes16167083garfishes
gawkish1835833gawkish
girlish1137193girlish
goatish1139563goa_tish
goldfish1644203goldfish
grayfish1844483grayfish
grayish1437813grayish
haggish15207473haggish
haimish1537753haimish
harpist12312353harpist
harsh116418053har__sh
hashish1238353hashish
hawkish2036553hawkish
headfish1845443headfish
hogfish17257023hogfish
huffish1935713huffish
jackfish2744123jackfish
jadish17319903ja_dish
jewfish2343543jewfish
kaddish16317973kaddish
laddish12299723laddish
ladyfish1843803ladyfish
ladyish14287823ladyish
laris54737463lar_is_
latish92416173la_tish
lavish124112983la_vish
lazyish22265853lazyish
maddish14289483maddish
maidish13239553maidish
mannish121710693mannish
marsh105320853mar__sh
mawkish1935823mawkish
monkfish2044003monkfish
moonfish1675333moonfish
moorish123311783moor_ish
mudfish1646263mudfish
narcism1188733narcism
narcist9512443narcist
naris55735293nar_is_
nerdish1137103nerdish
noirish1037883noir_ish
nourish1039703nour_ish
oafishly1754093oa_fishly
oafs76425263oa_f_s_
oaring74225303oar_ing
oarless73913373oarless
oarlike113411193oarlike
oars46846033oar__s_
oasis56422553oa_sis_
oddish11107653o_ddish
ogreism1044233ogreism
ogrism937913ogr_ism
oldish10169313o_ldish
onrush935343onr_ush
oralism9513763oralism
oralist7619633oralist
orangish1246553orangish
orisha936773o_r_isha
ornis54616773o_rnis_
orris54516553o_rris_
outwish13289853outwish
owlish1238703o_wlish
palish114718273pa_lish
parflesh1643743parflesh
pariah114320583par_iah
paris75145943par_is_
parvis116114803parvis_
parvise124211693parvise
perish114619063per_ish
perkish16258823perkish
pigfish16217173pigfish
pinfish15319303pinfish
poorish123712303poor_ish
pupfish1735533pupfish
radish103516913ra_dish
rakish134313963ra_kish
rammish1437563rammish
rankish14510383rankish
raspish1298103raspish
rattish10510823rattish
ravish123414033ra_vish
rawish123012913ra_wish
redfish1437793redfish
rockfish2043903rockfish
rosefish1445263rosefish
sailfish1446053sailfish
saltish10312163saltish
sandfish1556683sandfish
saris54544953sar_is_
selfish1388513selfish
sourish10310693sour_ish
sparkish17276973sparkish
spearfish1743603spearfish
sunfish1338883sunfish
surffish1744783surffish
tallish103313583tallish
tannish101610573tannish
tarbush1234173tarbush
toadish1139063toa_dish
toadyish1544153toadyish
tovarish1445123tovar_ish
vampish1766283vampish
vanish121513213va_nish
varnishy17163403varnishy
waggish15207073waggish
wampish1777293wampish
waspish1586923waspish
weakfish2143523weakfish
wearish132310153wear_ish
wolffish2043333wolffish
wolfish1636933wolfish
wormish1537163wormish
zanyish2235903zanyish
zarfs174713623zarf_s_

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.406440125.6
2DLD Change Limit1340272056.81019680.9
3Display Results2052050.0802562.5
 (SQL Overall)1786912057.29624491.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.