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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
taggers9351419(None) 
aggers85817791_aggers
baggers113915691baggers
daggers103714911daggers
gaggers103413661gaggers
jaggers164012891jaggers
laggers94216241laggers
naggers93812651naggers
saggers94017081saggers
staggers10379841staggers
tagger84017701tagger_
tuggers93711441tuggers
waggers124613081waggers
agers65027852_a_gers
agger76420892_agger_
angers75222542_angers
augers73818702_augers
badgers114812652badgers
bagger104619202bagger_
bangers104020352bangers
braggers12327902braggers
buggers114315662buggers
cadgers114712002cadgers
cagers95624192ca_gers
dagger95017302dagger_
dangers94818212dangers
diggers104413392diggers
doggers104413432doggers
draggers11357392draggers
eagers74523682ea_gers
eggers84612582_eggers
flaggers13328072flaggers
foggers124112012foggers
gagers84021332ga_gers
gagger95016512gagger_
gangers94418602gangers
gaugers94211712gaugers
hagglers13326622hagglers
hangers113120812hangers
hoggers124512482hoggers
huggers124211592huggers
jaegers15307102jaegers
jagers144415722ja_gers
jagger154016002jagger_
jaggery19336902jaggery
jiggers164010182jiggers
joggers164110692joggers
keggers13357042keggers
laagers83411252laagers
lagers74826142la_gers
lagger85919832lagger_
loggers94616132loggers
luggers93713482luggers
mangers103521262mangers
muggers113611932muggers
nagger84016122nagger_
niggers93111322niggers
pagers94423252pa_gers
raggees93710912raggees
rangers83621042rangers
riggers93613842riggers
ruggers94612312ruggers
saggars93610682saggars
sagger84321072sagger_
sangers84421942sangers
saugers83914052saugers
stagers84116672sta_gers
stagger94212392stagger_
staggery13346242staggery
swaggers13407222swaggers
tabers84621572ta_bers
tackers134319622tackers
tagged93418122tagge_d
tailers73720182tailers
takers103923742ta_kers
talers64628142ta_lers
talkers113513212talkers
tamers84224032ta_mers
tampers113516742tampers
tanagers9259002tanagers
tanglers92911972tanglers
tankers113416912tankers
tanners74018392tanners
tapers84025812ta_pers
tappers113416542tappers
targes74524592targe_s
targets84314222targets
tasters74225642tasters
taters64932202ta_ters
tatters74520482tatters
tawers94118602ta_wers
taxers134015282ta_xers
tigers75616512t_igers
toggery12505922toggery
togglers10276952togglers
tongers84116012tongers
triggers10257842triggers
tugger84013102tugger_
twangers12226062twangers
wagers105122202wa_gers
wagger113616012wagger_
waggery15276902waggery
yagers105114532ya_gers

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 Filter1786911076710.390458182.1
2DLD Change Limit1076711033.43631336.1
3Display Results1031030.0303433.3
 (SQL Overall)1786911033.85646341.0
 
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.