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

60 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
spelters10391224(None) 
pelters93720311_pelters
shelters113412811shelters
skelters12349371skelters
smelters103310511smelters
specters122811061specters
spellers102812761spellers
spelter94113701spelter_
swelters113110191swelters
belters93819412_belters
kelters113813752_kelters
melters93918312_melters
palters94021682_palters
pelter83321622_pelter_
pesters93827092_pesters
peters86624592_pe_ters
petters93722362_petters
pewters124113352_pewters
psalters10227712psalters
salters73622252s_alters
scepters1237802scepters
seaters74028942s_eaters
sellers73721322s_ellers
seltzers1735062s_eltzers
setters73822062s_etters
sheeters113111862sheeters
shellers112812582shellers
shelter103214962shelter_
shelvers14388812shelvers
skeeters12298962skeeters
skelter113610002skelter_
smellers10329772smellers
smelter93311912smelter_
smeltery13274962smeltery
spallers102910732spallers
spatters103914702spatters
speakers14299452speakers
spearers103711142spearers
specter113111732specter_
spectres12268682spectres
speeders11339312speeders
speers85019952spe__ers
speller95415152speller_
spelts84614642spelt__s
speltzes1944002speltzes
spencers12269192spencers
spenders113211742spenders
spewers124210662spe_wers
spielers10319652spiel_ers
spillers103311702spillers
spitters104113382spitters
sporters103714062sporters
spotters104313382spotters
spouters104011162spouters
spurters103311702spurters
sputters104012872sputters
svelter10359672svelter_
sweaters113811062sweaters
swelter103711172swelter_
welters103516062_welters

Search took 5 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 Filter1786911210590.483369960.7
2DLD Change Limit121059604.28328265.0
3Display Results60600.0134615.4
 (SQL Overall)178691604.77937390.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.