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 “billfishes” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

172 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
billfishes184425(None) 
billfish1645032billfish__
fallfishes1943982fallfishes
filefishes1944482filefishes
killifishes2152042killifishes
milkfishes2243122milkfishes
tilefishes1644602tilefishes
baitfishes1844053baitfishes
batfishes1746583b_atfishes
billies93923503bill_i__es
blemishes1665083b_lemishes
blindfishes2052583blindfishes
blowfishes2143463blowfishes
bluefishes1844313bluefishes
boarfishes1844973boarfishes
bonefishes1844913bonefishes
boxfishes2444153b_oxfishes
bullfights1951973bullfights
bullfinches2151213bullfinches
bullrushes1552523bullrushes
coalfishes1844693coalfishes
dealfishes1744193dealfishes
finfishes1846043fi_nfishes
foolfishes1943763foolfishes
goldfishes1863563goldfishes
jellyfishes2781843jellyfishes
kingfishes2143703kingfishes
lionfishes1643543lionfishes
pigfishes1845003pi_gfishes
pilotfishes1962133pilotfishes
pinfishes1746243pi_nfishes
pipefishes2043793pipefishes
sailfishes1644643sailfishes
shellfishes2052583shellfishes
swellfishes2052143swellfishes
wolffishes2242983wolffishes
abolishes1446054abol_ishes
angelfishes1862694angelfishes
bakshishes2242004bakshishes
balefires1444804balefi_res
ballies93725744ball_i__es
banishes131812464b__anishes
bellies94023724bell_i__es
bellyaches2052044bellyaches
bialies93618414bial_i__es
biblists1236874bibl_is_ts
biffies152710854bi_ffi__es
bilbies114712344bi_lbi__es
billfolds1542774billf_olds
billiards1245024bill_iards
billie85019174bill_i__e_
billings113412634bill_i_ngs
billions102211794bill_i_ons
biolyses1345574biol_ys_es
bisulfides16152234bisulfi_des
bisulfites15152664bisulfi_tes
blackfishes2543504blackfishes
blandishes1644614blandishes
blemished1763784b_lemished
blemisher1663654b_lemisher
blemishers1763014b_lemishers
blisses94911514b__l_isses
blushes124314824b__l_ushes
bollixes1747204boll_i_xes
brandishes1645894brandishes
bullfight1842934bullfigh_t
bullfighter2051294bullfighter
bullfighters216994bullfighters
bullies94121894bull_i__es
bullish12511194bull_ish__
bullishly1744084bull_ishly
bullishness1643954bull_ishness
bullnoses1144704bullnos_es
bulrushes1443324b_ulrushes
burnishes1436644b_urnishes
catfishes1746304_catfishes
cavefishes2143864cavefishes
clingfishes2052544clingfishes
codfishes1845644_codfishes
cowfishes2045724_cowfishes
crawfishes2143594crawfishes
crayfishes2143404crayfishes
cullises103111314cull_is_es
devilfishes2151994devilfishes
dillies84122164dill_i__es
diminishes1644974diminishes
dogfishes1745084_dogfishes
drumfishes1942754drumfishes
embellishes1852094embell_ishes
englishes1345104engl_ishes
fallfish1744464fallfish__
filefish1745594filefish__
fillies103420254fill_i__es
fillister1244424fill_ister
fillisters1343874fill_isters
finishes1438984fi__nishes
fishes125221344____fishes
flatfishes1943994flatfishes
flemishes1765244_flemishes
foxfishes2544054_foxfishes
frogfishes2043324frogfishes
garfishes16167084_garfishes
gillies84120964gill_i__es
goatfishes1743934goatfishes
grayfishes2043634grayfishes
hagfishes1945154_hagfishes
headfishes2044414headfishes
hellfires1564464hellfi_res
hillsides1344554hillsi_des
hogfishes1944684_hogfishes
illites72415014_ill_i_tes
illnesses937284_illnesses
jackfishes2943764jackfishes
jewelfishes2751784jewelfishes
jewfishes2543384_jewfishes
killies113318114kill_i__es
killifish1942674killifish__
kingfisher2152244kingfisher
kingfishers2251714kingfishers
ladyfishes2052844ladyfishes
lavishes1457404__lavishes
lumpfishes2042874lumpfishes
lungfishes1743414lungfishes
milkfish2043334milkfish__
milliares1149404mill_iares
milliemes13255844mill_iemes
millimes122411374mill_i_mes
millimhos1642894mill_imhos
millines102718064mill_i_nes
milliohms1643674mill_iohms
minishes13310584mi__nishes
monkfishes2243744monkfishes
moonfishes1844194moonfishes
mudfishes1844194_mudfishes
numbfishes2042784numbfishes
oarfishes15156954_oarfishes
outfishes15118024_outfishes
overfishes1947014overfishes
panfishes1737594_panfishes
planishes14138524_planishes
plenishes1487084_plenishes
polishes13711784_pol_ishes
publishes1645934publ_ishes
pupfishes1944314_pupfishes
ratfishes1546104_ratfishes
redfishes1645794_redfishes
relishes11311954_rel_ishes
rockfishes2263514rockfishes
rosefishes1644114rosefishes
sablefishes1952894sablefishes
sandfishes1745544sandfishes
sawfishes1845744_sawfishes
sillies73425084sill_i__es
silverfishes2151784silverfishes
starfishes1646154starfishes
studfishes17103794studfishes
suckfishes2243434suckfishes
sunfishes1547034_sunfishes
surffishes1984074surffishes
tallises82713264tall_is_es
tallithes12286574tall_ithes
tilefish1445454tilefish__
tillites8312834till_i_tes
toadfishes1743794toadfishes
vigorishes1743114vigorishes
vilifies1439594vilifi__es
villainies1344114villainies
viperfishes2252504viperfishes
weakfishes2343354weakfishes
whitefishes2352644whitefishes
wildfires1642834wildfi_res
willies103920154will_i__es

Search took 10 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 Filter1786911614500.1731032896.0
2DLD Change Limit1614501729.64016747.9
3Display Results1721720.0762263.2
 (SQL Overall)1786911729.88918069.7
 
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.