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 “spellers” 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
spellers10281276(None) 
sellers73721321s_ellers
shellers112812581shellers
smellers10329771smellers
spallers102910731spallers
speller95415151speller_
spelters103912241spelters
spillers103311701spillers
cupellers1374862cupellers
dispellers13115452dispellers
duellers9268222duellers
dwellers12356082dwellers
expellers18104752expellers
fellers104117542_fellers
fuellers11277982fuellers
gospellers1363022gospellers
hellers103619832_hellers
impellers1345102impellers
pedlers103013272_pedlers
peelers93615592_peelers
pellets94014782_pellets
pelters93720312_pelters
pollers93420022_pollers
pullers93618482_pullers
quellers17237532quellers
repellers11278882repellers
scullers103510482scullers
sealers74323552s_ealers
seller63824602s_eller_
selles64426982s_elle_s
sheller103515892sheller_
shelters113412812shelters
shelvers14388812shelvers
sillers73822102s_illers
skelters12349372skelters
smeller94212792smeller_
smelters103310512smelters
sneller73512852sneller_
spaller92713472spaller_
speakers14299452speakers
spearers103711142spearers
specters122811062specters
speeders11339312speeders
speers85019952spe__ers
spelled103714742spelle_d
spells84617682spell__s
spelter94113702spelter_
spencers12269192spencers
spenders113211742spenders
spewers124210662spe_wers
spielers10319652spielers
spiller92914332spiller_
spoilers10238632spoilers
spoolers10349362spoolers
stealers83412212stealers
sweller103012472sweller_
swelters113110192swelters
swillers11299112swillers
tellers73717602_tellers
yellers103912952_yellers

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.406440125.6
2DLD Change Limit121059603.95330624.6
3Display Results60600.0302000.0
 (SQL Overall)178691604.38940713.4
 
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.