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

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

62 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
salmis851427(None) 
salamis9313511salamis
salmi7815861salmi_
aaliis6312902aaliis
almas76629772_almas
almes75126542_almes
alms65834922_alm_s
amis66445322_a_mis
balms95723922balm_s
calms95222352calm_s
filmis114610282filmis
halmas117017892halmas
halms105225212halm_s
kalmia1238892kalmia
kalmias1347972kalmias
malms95021552malm_s
palais8420422palais
palmist112814342palmist
palms94921752palm_s
psalmic1345332psalmic
psalmist1276352psalmist
psalms1045672psalm_s
sadis64930852sa_dis
saimin8313662saimin
saimins9312112saimins
sakis95323672sa_kis
salads75316962salads
salals65120082salals
salami8313102salami_
saleps85014902saleps
sales56055592sal_es
salic73424712sal_ic
sallies73227812sallies
salmon84614182salmon
salmons93713262salmons
salols64017872salols
salons63823692salons
salpas85116922salpas
salpid9510882salpid
salpids1038192salpids
salps74423242sal_ps
sals46851672sal__s
salsas65316132salsas
saltie63422432saltie
salties73725772salties
saltish10312162saltish
salts55431882sal_ts
salukis1136032salukis
salves94221762salves
salvia93310752salvia
salvias10279932salvias
salvos94613382salvos
samps96124672sa_mps
saris54544952sa_ris
satis55633682sa_tis
semis74623532s_emis
slams74927902slam_s
slims75423652s_lims
swamis114212292swamis
sylis84316022syl_is
tallis63319962tallis
tamis76728732ta_mis

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551622.50033020.4
3Display Results62620.0163875.0
 (SQL Overall)178691622.87662131.8
 
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.