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

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

87 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
catfishes174630(None) 
batfishes1746581batfishes
ratfishes1546101ratfishes
baitfishes1844052baitfishes
catfights1842792catfights
catfish1559022catfish__
cavefishes2143862cavefishes
coalfishes1844692coalfishes
codfishes1845642codfishes
cowfishes2045722cowfishes
crawfishes2143592crawfishes
crayfishes2143402crayfishes
flatfishes1943992flatfishes
garfishes16167082garfishes
goatfishes1743932goatfishes
hagfishes1945152hagfishes
oarfishes15156952oarfishes
outfishes15118022outfishes
panfishes1737592panfishes
sawfishes1845742sawfishes
affiches1945233_affiches
banishes131812463ba_nishes
batfish1558683batfish__
batistes1039713bat_istes
boarfishes1844973boarfishes
boxfishes2444153boxfishes
caddises12329353caddis_es
calashes13310533ca_lashes
caliches153812263ca_liches
camises114218463ca_mis_es
carwashes1745773carwashes
cashes114729883ca___shes
cassises103811743cassis_es
catches144320773cat__ches
catfaces1536963catf_aces
catfight1744273catfigh_t
catties94023053catti__es
cattish12410723cattish__
cattishly1743473cattishly
cherishes1767563cherishes
crampfishes2352263crampfishes
crawfished2242253crawfished
cuishes122810823c__uishes
cutises94414913cut_is_es
danishes121710493da_nishes
dealfishes1744193dealfishes
dogfishes1745083dogfishes
fallfishes1943983fallfishes
famishes1658283fa_mishes
fetishes1437153fet_ishes
finfishes1846043finfishes
fishes125221343___fishes
foxfishes2544053foxfishes
garnishes13198813garnishes
grayfishes2043633grayfishes
hashishes1444393hashishes
headfishes2044413headfishes
hogfishes1944683hogfishes
jackfishes2943763jackfishes
jewfishes2543383jewfishes
kaddishes1844093kaddishes
ladyfishes2052843ladyfishes
lavishes1457403la_vishes
marishes13512553ma_rishes
mudfishes1844193mudfishes
outfished16116603outfished
outwishes15126563outwishes
parishes13314753pa_rishes
pigfishes1845003pigfishes
pinfishes1746243pinfishes
platyfishes2252193platyfishes
pupfishes1944313pupfishes
radishes1269463ra_dishes
ratfish1338773ratfish__
ravishes1478043ra_vishes
redfishes1645793redfishes
sailfishes1644643sailfishes
sandfishes1745543sandfishes
sheatfishes2052483sheatfishes
starfishes1646153starfishes
sunfishes1547033sunfishes
tarnishes12188893tarnishes
toadfishes1743793toadfishes
vanishes141610753va_nishes
varnishes15207913varnishes
wampishes1944303wampishes
weakfishes2343353weakfishes

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641879.47015696.0
3Display Results87870.0302900.0
 (SQL Overall)178691879.67318473.2
 
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.