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

157 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
boxfish228554(None) 
foxfish2354481foxfish
batfish1558682batfish
blowfish1944702blowfish
boarfish1635752boarfish
boarish123911912boarish
boggish14238652boggish
bonefish1646282bonefish
boobish14338942boobish
bookish163610022bookish
boorish123712592boorish
boxfishes2444152boxfishes
boyish142911232bo_yish
codfish1637162codfish
cowfish1836432cowfish
dogfish15226762dogfish
hogfish17257022hogfish
oafish121311722_oafish
offish15137272_offish
wolfish1636932wolfish
abolish12311503abo_lish
babyish1736513babyish
baitfish1645483baitfish
baldish1339503baldish
banish111416043b_anish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
biggish14247503biggish
billfish1645033billfish
blemish1436603blemish
blockish19115793blockish
blondish1476173blondish
bluefish1645143bluefish
blueish1236483blueish
bluish1159243b_luish
boccis123911133boccis_
boffin14359053boffi_n
boffing16339983boffing
boffins15329073boffins
boffos14568193boffos_
boffs134915503bo_ffs_
bogyism1545213bogyism
bonfire1287063bonfire
bosh96328973bo___sh
bossism1136063bossism
bowfin14338353bowfi_n
bowfins15267703bowfins
boxers155013483boxers_
boxes145625073box_es_
boxful18145273boxf_ul
boxfuls19113603boxfuls
boxier154311743box_ier
boxiest163711983boxiest
boxily1877843box_ily
boxing163915153box_ing
boxlike20267073boxlike
brinish1239963brinish
broadish1446933broadish
broguish1444103broguish
brownish1645643brownish
brutish1237703brutish
buckish18237883buckish
bullish12511193bullish
burnish1238623burnish
catfish1559023catfish
coalfish1635493coalfish
cockish1838503cockish
coldish1399303coldish
coltish121310933coltish
coolish12312523coolish
coyish143710393co_yish
deafish1438533deafish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dovish1338103do_vish
elfish1267963_elfish
finfish16268193finfish
fish106926273___fish
fogyish1735363fogyish
folkish1736563folkish
foolfish1744393foolfish
foolish1339613foolish
foppish1735103foppish
foxfire2042563foxfire
foxfishes2544053foxfishes
frogfish1843943frogfish
garfish14179203garfish
goatfish1544293goatfish
goatish1139563goatish
goldfish1644203goldfish
goodish1237963goodish
goyish13379013go_yish
hagfish17227613hagfish
hoggish15247593hoggish
hottish13117903hottish
huffish1935713huffish
jewfish2343543jewfish
lionfish1454093lionfish
loggish12258733loggish
longish11229093longish
loudish1137983loudish
loutish1039963loutish
lowish12310533lo_wish
mobbish1635923mobbish
modish123813543mo_dish
monish114217593mo_nish
monkfish2044003monkfish
monkish1638243monkish
moonfish1675333moonfish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
mudfish1646263mudfish
noirish1037883noirish
nourish1039703nourish
oarfish13158613oarfish
oddish11107653_oddish
ogrish1039263_ogrish
oldish10169313_oldish
outfish132210573outfish
owlish1238703_owlish
panfish15229973panfish
pigfish16217173pigfish
pinfish15319303pinfish
pixyish2253653pixyish
polish114916723po_lish
poorish123712303poorish
popish133812113po_pish
pupfish1735533pupfish
raffish1658843raffish
ratfish1338773ratfish
redfish1437793redfish
rockfish2043903rockfish
roguish1156833roguish
rompish1436693rompish
rosefish1445263rosefish
sawfish1637683sawfish
selfish1388513selfish
serfish1348973serfish
softish13127813softish
sottish10129443sottish
sourish10310693sourish
sunfish1338883sunfish
toadfish1544903toadfish
toadish1139063toadish
tonish93415903to_nish
tonnish10149093tonnish
townish13167933townish
toyish122911123to_yish
voguish1465203voguish
waifish1637703waifish
woggish15276673woggish
wolffish2043333wolffish
wormish1537163wormish

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 Limit1340271577.14018771.3
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.60923484.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.