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

58 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
sandfishes174554(None) 
panfishes1737592pan_fishes
sailfishes1644642sailfishes
sandfish1556682sandfish__
sandwiches1962132sandwiches
sawfishes1845742sa_wfishes
standishes1445712stand_ishes
studfishes17103792studfishes
sunfishes1547032sun_fishes
anguishes1345093_anguishes
baitfishes1844053baitfishes
banishes131812463ban__ishes
batfishes1746583ba_tfishes
blandishes1644613bland_ishes
blindfishes2052583blindfishes
bonefishes1844913bonefishes
brandishes1645893brand_ishes
candlefishes2152003candlefishes
catfishes1746303ca_tfishes
cavefishes2143863cavefishes
codfishes1845643_codfishes
danishes121710493dan__ishes
fallfishes1943983fallfishes
finfishes1846043fin_fishes
garfishes16167083ga_rfishes
goldfishes1863563goldfishes
hagfishes1945153ha_gfishes
headfishes2044413headfishes
jackfishes2943763jackfishes
kaddishes1844093ka_ddishes
kingfishes2143703kingfishes
ladyfishes2052843ladyfishes
languishes1444243languishes
lungfishes1743413lungfishes
monkfishes2243743monkfishes
mudfishes1844193_mudfishes
oarfishes15156953oa_rfishes
pinfishes1746243pin_fishes
radishes1269463ra_d_ishes
ratfishes1546103ra_tfishes
redfishes1645793_redfishes
sablefishes1952893sablefishes
sandflies1346513sandf_lies
sandpiles1246303sandpi_les
sandshoes1345213sand__shoes
sandwiched2071543sandwiched
sanitises91111743sanitis_es
snakefishes2152413snakefishes
spadefishes2052693spadefishes
starfishes1646153starfishes
stonefishes1753713stonefishes
suckfishes2243433suckfishes
surffishes1984073surffishes
swordfishes2152163swordfishes
toadfishes1743793toadfishes
tundishes1344543tund_ishes
vanishes141610753van__ishes
vanquishes2542943vanquishes

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603586.43621846.3
3Display Results58580.0331757.6
 (SQL Overall)178691586.87525991.4
 
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.