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

43 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
kashmir1616240(None) 
kashmirs17132241kashmirs
kasher134915032kash_er
amir65129753_a__mir
ashier94714833_ashier
ashlar9338193_ashlar
ashler9459973_ashler
ashman1148383_ashman
ashmen1168173_ashmen
astir55517093_as_tir
basher115123813bash_er
cashier123713323cashier
cashmere1564323cashmere
casimire1244773casimire
dasher104318983dash_er
dashi95013113dash_i_
dashier114311183dashier
dashis104414393dash_is
gasher104320373gash_er
jasmin1538073jas_min
kaffir16345303ka_ffir
kafir12488903ka__fir
kalmia1238893ka_lmia
kami105823643ka__mi_
kamik105011553ka__mik
karmic1438113ka_rmic
kasha124710723kash__a
kashas133311903kash_as
kashers143914023kashers
kashrut1444913kashrut
kosher134412973kosh_er
lasher94824533lash_er
lashkar1443703lashkar
masher114123203mash_er
mashie11315933mash_ie
pashmina1543313pashmina
rasher95024123rash_er
sashimi1244643sashimi
sashimis1343753sashimis
washer124720393wash_er
washier133611153washier
yashmac1742563yashmac
yashmak1942743yashmak

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 Filter1786911340270.406440125.6
2DLD Change Limit134027435.65623696.4
3Display Results43430.0162687.5
 (SQL Overall)178691436.07829399.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.