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

71 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
skelpit134494(None) 
kelpie12308612_kelpie
shilpit1247102shilpit
skelp114211422skelp__
skelped1435202skelped
skelping1535972skelping
skelps12407922skelp_s
skylit1338282skyl_it
coalpit1148513coalpit
fleapit1255993fleapit
kelim11912553_kel_im
keloid11812623_keloid
kelp105322803_kelp__
kelped13449553_kelped
kelpies13289903_kelpies
kelping14319193_kelping
kelps115116423_kelp_s
kelpy145110683_kelp_y
kelt85343193_kel__t
kelvin13117323_kelvin
kempt134318463_kemp_t
kepi105315633_ke_pi_
kepis115313363_ke_pis
kept106232943_ke_p_t
kewpie15465413_kewpie
klepht1535043_klepht
pulpit10310933_pulpit
relit55340683_rel_it
salpid9510883s_alpid
sandpit1049633sandpit
sculpin11236653sculpin
sculpt104412693sculp_t
select82621173s_elect
selkie102811693s_elkie
sennit63117923s_ennit
sepia75318673s_e_pia
sepic94617053s_e_pic
sept65844363s_e_p_t
sexpot1539543s_expot
sheltie10109913sheltie
skaldic1443553skaldic
skeet95429183ske__et
skein94814413ske__in
skell94915833skel__l
skells105013783skel_ls
skellum1343853skellum
skelm114211293skel__m
skelms12368023skel_ms
skelter113610003skelter
skep105219353ske_p__
skeps115614253ske_p_s
skepsis1344253skepsis
skeptic1545203skeptic
skillet113512153skillet
skippet15288463skippet
skit85437533sk___it
sklent103614353sk_lent
sleekit1145453sleekit
slept75728103sle_p_t
slipt76627483s__lipt
slit46250103s__l_it
smelt74726783smel__t
snakepit1453963snake_pit
spelt75430193spel__t
spit65545083s___pit
split75729013s_pl_it
stelai63912563stelai_
stelic8313083stel_ic
stellite839533stellite
sunlit61516103sunl_it
swept105720603swe_p_t

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 Filter1786911340270.406440125.6
2DLD Change Limit134027716.51620568.9
3Display Results71710.0135461.5
 (SQL Overall)178691716.93525766.5
 
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.