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

50 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
spence10381379(None) 
pence94924451_pence
spencer113610971spencer
spences113413921spences
spense83912431spense
essence947672essence
fence105319912_fence
hence104920042_hence
peace95026082_peace
pencel103812912_pencel
penne75423852_penne
ponce95222512_ponce
sapience12106612sapience
scene77220572scen_e
science1138782science
sconce104711722sconce
seance83716692seance
sene46848052s_en_e
sense55526822s_ense
sente56432882s_ente
silence9310212silence
since75024172s_ince
sixpence1943542sixpence
skene96118122sken_e
space95325672sp_ace
spancel1147362spancel
spec85821972spe_c_
specced14266702specced
specie10412222specie
speck135115652spe_ck
specs96916672spe_cs
speech1347562speech
speise84614252speise
spencers12269192spencers
spend85619332spen_d
spender103713692spender
spends94714472spends
spendy124911142spendy
spenses92913572spenses
spent75532832spen_t
sphene113412402sphen_e
spice95528812sp_ice
spine76534422spin_e
splice104915102splice
sponge939662sponge
spruce103910872spruce
stance84316912stance
stench114111162stench
thence112010842thence
whence14187922whence

Search took 4 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 Filter178691825510.330541487.9
2DLD Change Limit82551502.71630394.3
3Display Results50500.0163125.0
 (SQL Overall)178691503.06258357.6
 
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.