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

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

75 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
skimp13541131(None) 
simp85228771s_imp
skim105322491skim_
skimo116312531skimo
skimps14488041skimps
skimpy17475721skimpy
skims114517181skims
skip105421741ski_p
blimp115612942blimp
chimp145216472chimp
crimp115615802crimp
gimp96124042_gimp
imp76626972__imp
jimp155618462_jimp
kemp126418762_kemp
kip97042132_ki_p
limp88432492_limp
pimp106024902_pimp
primp115615922primp
samp85733592s_amp
scamp115717312scamp
scrimp125110582scrimp
shim95827842shim_
shims104422542shims
ship95228232shi_p
shrimp13478762shrimp
sim56553132s_im_
sima64730782s_ima
simps94719762s_imps
sims65737172s_ims
sip57656012s_i_p
skelp114211422skelp
skep105219352sk_ep
ski74925682ski__
skid95720912ski_d
skids104615322skids
skied104417752skied
skier95119592skier
skies95026832skies
skiey125012892skiey
skiff153612802skiff
skill94316722skill
skimos12548802skimos
skimped16256222skimped
skin85927522ski_n
skink85916852skink
skins94723462skins
skint95629222skint
skips115616602skips
skirl96012912skirl
skirr94810542skirr
skirt95624662skirt
skis84825282ski_s
skit85437522ski_t
skite95120042skite
skits94721852skits
skive124614112skive
slim66631952slim_
slime74925752slime
slims75423652slims
slimy105417422slimy
slip67031732sli_p
slump94816632slump
snip66424652sni_p
stamp95217362stamp
stime76521792stime
stimy105114732stimy
stirp76815502stirp
stomp95616662stomp
stump94616462stump
sump86331532s_ump
swamp125015322swamp
swim96221392swim_
swims105514142swims
wimp115521522_wimp

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800751.62633087.3
3Display Results75750.0135769.2
 (SQL Overall)178691751.732103170.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.