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

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

31 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
spinachlike225102(None) 
spinelike1585353spin__elike
epiclike1644144epi__c_like
pincerlike1843004_pincerlike
pinelike14188614_pin__elike
pinochle1544744_pinochl__e
ranchlike1844084_ran_chlike
sacklike1337304s___acklike
saclike131210124s___ac_like
saintlike1344784sain__tlike
sennachie1453294sennach_i_e
shanachie1743534shanach_i_e
sighlike1635534s_i__ghlike
sinuslike1343504s_in_uslike
skinlike1134874skin___like
snaglike1335284s__na_glike
snaillike1343774s__naillike
snakelike1244294s__nakelike
sparlike1437674sp__a_rlike
spearlike1544144sp_ea_rlike
sphinxlike2651504sphin__xlike
spiderlike1742564spi_derlike
spikelike14103874spi__kelike
spinach1435404spinach____
spinaches1645274spinach__es
spinachy1842794spinach___y
spiracle1255804spirac_l__e
springlike1742994sprin__glike
sticklike1444004sti__cklike
suchlike1735124s___uchlike
witchlike2143104_wi_tchlike

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 Filter1786911488190.423422437.4
2DLD Change Limit148819318.59317318.6
3Display Results31310.0161937.5
 (SQL Overall)178691319.03219784.2
 
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.