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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
platyfishes225219(None) 
flatfishes1943992flat_fishes
ladyfishes2052842_ladyfishes
platyfish2042682platyfish__
batfishes1746583_bat_fishes
blackfishes2543503blackfishes
catfishes1746303_cat_fishes
crayfishes2143403cra_yfishes
goatfishes1743933goat_fishes
grayfishes2043633gra_yfishes
panfishes1737593p_a_nfishes
pilotfishes1962133pilot_fishes
planishes14138523pla__nishes
platypuses1751623platypus_es
ratfishes1546103_rat_fishes
baitfishes1844054_baitfishes
blandishes1644614bla_ndishes
blindfishes2052584blindfishes
blowfishes2143464bl_owfishes
bluefishes1844314bl_uefishes
boarfishes1844974boa_rfishes
cavefishes2143864_cavefishes
clingfishes2052544clingfishes
coalfishes1844694coa_lfishes
crampfishes2352264crampfishes
crawfishes2143594cra_wfishes
dealfishes1744194dea_lfishes
fallfishes1943984_fallfishes
flatfish1744934flat_fish__
flatwashes1941944flat_washes
garfishes16167084_ga_rfishes
globefishes2052314globefishes
hagfishes1945154_ha_gfishes
headfishes2044414hea_dfishes
jackfishes2943764_jackfishes
jellyfishes2781844jellyfishes
ladyfish1843804_ladyfish__
languishes1444244_languishes
lavishes1457404_la__vishes
lionfishes1643544_lionfishes
lumpfishes2042874_lumpfishes
lungfishes1743414_lungfishes
oarfishes15156954_oa_rfishes
outfishes15118024_out_fishes
parishes13314754p_a__rishes
pigfishes1845004p__igfishes
pinfishes1746244p__infishes
pipefishes2043794p_ipefishes
planished1566124pla__nished
planisher1495854pla__nisher
planishers1584774pla__nishers
plashes124417394pla____shes
platies93722544plat__i__es
platinizes2147794platini_zes
platonisms1466334platonis_ms
playfields1951154pla_yfields
playlists1444784pla_ylis_ts
playtimes1644414pla_yti_mes
plenishes1487084pl__enishes
pupfishes1944314p__upfishes
sailfishes1644644_sailfishes
sandfishes1745544_sandfishes
sawfishes1845744_sa_wfishes
sheatfishes2052484sheat_fishes
snakefishes2152414snakefishes
spadefishes2052694spadefishes
spearfishes1953164spea_rfishes
starfishes1646154sta_rfishes
toadfishes1743794toa_dfishes
weakfishes2343354wea_kfishes
whitefishes2352644whitefishes

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 Filter1786911488190.436409841.7
2DLD Change Limit148819719.17316223.6
3Display Results71710.0461543.5
 (SQL Overall)178691719.65518507.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.