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

55 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
salmonid114763(None) 
salmonids1245541salmonids
salmonoid1243881salmonoid
almond91410432_almon_d
salmon84614182salmon__
salmonoids1352762salmonoids
salmons93713262salmon_s
algoid83011473_algo_id
alimonied1284843_alimonied
almonds10127953_almonds
almondy13144483_almondy
almoner949383_almoner
almonry12104733_almonry
ammonia1148693_ammonia
ammonic1349163_ammonic
ammonoid13104803_ammonoid
balconied1444853balconied
daemonic1356913daemonic
daimonic1346603daimonic
daltonic1146523daltonic
falconoid1553153falconoid
gammoned1444993gammoned
haemoid1337203haemo_id
haloid104317763hal_o_id
harmonic1589433harmonic
psalmodic1652433psalmodic
pulmonic1445033pulmonic
sallowed12149033sallowed
salmi7815863salm__i_
salmis8514273salm__is
salon55228553sal_on__
salons63823693sal_on_s
saloon64418023saloon__
saloons74415323saloon_s
salpid9510883sal__pid
salvoed11307063salvo_ed
salvoing1236423salvoing
samoyed1335893sa_moyed
santonin849703santonin
saponin9310263sa_ponin
sarcoid10310453sarco_id
sardonic1147453sardonic
sermonic1248883sermonic
sialoid8310963sial_o_id
sigmoid1146113sigmo_id
sloid64619713s_l_o_id
solenoid947873solenoid
somoni8310743s_omoni_
spumoni1173453spumoni_
spumonis1264113spumonis
sulfonic1344703sulfonic
summoned1345723summoned
taloned8310223tal_oned
valgoid1255213valgo_id
valonia1048303val_onia

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 Filter1786911461620.830215290.4
2DLD Change Limit146162558.64016916.9
3Display Results55550.0163437.5
 (SQL Overall)178691559.48618837.3
 
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.