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

45 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
spelunks144236(None) 
spelunk1343201spelunk_
plunks124711162_p_lunks
spelunked1641542spelunked
spelunker1541962spelunker
spelunkers1641762spelunkers
spunks12349332sp__unks
apolunes1045293apolunes
clunks124811013__clunks
debunks1433763_debunks
flunks13469863__flunks
lunks94822453___lunks
planks124116753_p_lanks
plinks124913263_p_links
plonks124210423_p_lonks
plucks14379733_p_lucks
plunk114514403_p_lunk_
plunky15377953_p_lunky
punks114822683_p__unks
relinks114510223_relinks
shelducks1951913shelducks
skunks9468163s__kunks
slinks104315153s__links
slunk95016303s__lunk_
spanks124514123sp__anks
speaks125114583spe__aks
speans85417143spe_an_s
specks144312703spe__cks
spellers102812753spellers
spellings12296553spellings
spells84617683spel__ls
spelters103912243spelters
spelts84614643spel__ts
speltzes1944003speltzes
spelunking17112003spelunking
spelunkings18131113spelunkings
spends94714473spe__nds
spilings11308813spilings
spleens937103spleen_s
splents93912133sp_lents
splines94718893sp_lines
splints94511743sp_lints
spunk114513403sp__unk_
spunky15427163sp__unky
uplinks13345613up_links

Search took 9 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 Limit146162458.01618233.8
3Display Results45450.0133461.5
 (SQL Overall)178691458.45221141.9
 
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.