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

49 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
stimulus104433(None) 
limulus935082_limulus
stimuli944512stimul_i
stipules1037052stipules
tumulus935032_tumulus
apiculus1245413apiculus
cumulus1135453_cumulus
famulus1235043_famulus
fumulus1234443_fumulus
hamulus1235323_hamulus
primulas1246123primulas
sacculus1244813sacculus
similes92915233s_imiles
simious939803s_imious
simples113014943s_imples
simular938673s_imular
simulars1047073s_imulars
sinuous739063s_inuous
spicules12219803spicules
spiculum1464213spiculum
spinules10249333spinules
spirulas10207203spirulas
stickles142512103stickles
stifles103013393sti_fles
stiles64328773sti__les
stills64118573sti__lls
stilts67915313sti__lts
stimes85920573stim__es
stimies9316563stim_ies
stimulant1145163stimulant
stimulants1253373stimulants
stimulate1148233stimulate
stimulates1247383stimulates
stipels9418953stipel_s
stipples1247023stipples
stipular1045843stipular
stipule936723stipul_e
stipuled1134453stipuled
stridulous1152713stridulous
strumous1045733strumous
stulls63912983st__ulls
stumbles1237493stumbles
stylus9397463st__ylus
sulus54821883s___ulus
timeous938403_timeous
tristimulus136893tristimulus
tumulous1045303_tumulous
tumults934823_tumults
utriculus1143873utriculus

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 Filter1786911461620.423422437.4
2DLD Change Limit146162497.22020244.0
3Display Results49490.0301633.3
 (SQL Overall)178691497.67323288.3
 
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.