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

67 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
sashimi124464(None) 
sashimis1343751sashimis
dashiki1544202dashiki
santimi938792santimi
sashing114621472sashing
animi74016663_a_nimi
ashier94714833_ashier
ashing107824093_ashing
bashing135422583bashing
cashier123713323cashier
cashing135022553cashing
casini84615863cas_ini
daishiki1642043daishiki
dashi95013113dash__i
dashier114311183dashier
dashikis1643673dashikis
dashing125917893dashing
dashis104414393dashi_s
fashing144918793fashing
fashion1337843fashion
gashing125119233gashing
hashing145020163hashing
hashish1238353hashish
kashmir16162403kashmir
lashing114422893lashing
lashins103915153lashins
mashie11315933mashi_e
mashies12318253mashies
mashing134422243mashing
pachisi14329523pachisi
pashing135120513pashing
passim10410283passim_
pastime114611973pastime
sachem134012223sachem_
sachemic1746083sachemic
sachems14348903sachems
sahib10314763sa_hi_b
sahibs1137083sa_hibs
saimin8313663sa__imin
salami8313103sa_lami
salmi7815863sa__lmi
santims9312603santims
santimu938563santimu
sash77235303sash___
sashay1238363sash_ay
sashays1336333sashays
sashed105622943sash_ed
sashes94728483sash_es
sasin54626573sas_i_n
sasins64923103sas_ins
sassier73413233sassier
sassies74719263sassies
sassily1038723sassily
sassing84615553sassing
shim95827863__shim_
shims104422553__shims
slashing123713413slashing
smashing143310243smashing
stashing123511583stashing
stasima955633stas_ima
surimi839103s_urimi
sushi8310493sush__i
sushis9311183sushi_s
swashing15369743swashing
tahini939893ta_hini
washier133611153washier
washing145119283washing

Search took 8 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 Limit134027677.36018210.2
3Display Results67670.0164187.5
 (SQL Overall)178691677.78222962.1
 
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.