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

37 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
spinnaker154231(None) 
spinnakers1641911spinnakers
spinner93912262spinn__er
gennaker1342923_gennaker
pinker125322443_pi_n_ker
pinnace113510313_pinnace_
pinnaces12268863_pinnaces
pinnae84414643_pinna_e_
pinnate93613743_pinnate_
pinnated11338553_pinnated
pinner84521503_pinn__er
rainmaker1544393rainmaker
sailmaker1543973sailmaker
signaler945453s_ignaler
sinker103620903s_i_n_ker
sinner64320603s_inn__er
skinker10319443ski_n_ker
skinner11348093skinn__er
skinnier1264893skinn_ier
sneaker112910453s__neaker
spanker133612353sp_an_ker
spanner94312563spann__er
speaker133311213sp__eaker
spiker124315663spi___ker
spinage10289653spi_nage_
spinages11289293spi_nages
spinate93114813spi_nate_
spindler11297983spi_ndler
spindlier1253873spindlier
spinier93715163spi_n_ier
spinneret1146193spinneret
spinners103810863spinn__ers
spinnery13416593spinn__ery
spinney12438923spinn__ey
spinnies103210543spinn_ies
spinster1036683spi_nster
stinker113313313sti_n_ker

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 Filter1786911486410.440406115.9
2DLD Change Limit148641376.29623608.8
3Display Results37370.0132846.2
 (SQL Overall)178691376.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.