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

128 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
sneers6401617(None) 
seers55136381s_eers
sheers94322401sheers
sneer54919951sneer_
sneery93610411sneery
speers85019951speers
steers63820981steers
ameers84015572ameers
anears63717182anears
angers75222542angers
beers75628392_beers
cheers114518912cheers
deers64930522_deers
emeers83314182emeers
enders74324052enders
enters64425642enters
fleers96015792fleers
freers94717302freers
infers93615442infers
inkers104018832inkers
inners63919352inners
inters64328052inters
jeers124818132_jeers
kneels10408932kneels
knees95114872knee_s
leers54828982_leers
nears55529422_nears
needs65719632_needs
neems77316292_neems
neeps75617882_neeps
peers75130272_peers
queers153510772queers
sabers85224732sabers
sakers104125432sakers
sanders84025942sanders
sangers84421942sangers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
sears54744912s_ears
seders74420282seders
seeders83017112seeders
seeds64330062s_eeds
seekers113712332seekers
seeks94724642s_eeks
seels55632822s_eels
seemers93814332seemers
seems75525022s_eems
seeps74828752s_eeps
seer45547042s_eer_
sees45361052s_ee_s
senders83022352senders
senors63620792senors
seres55448892s_eres
sers45746652s__ers
severs94121122severs
sewers94719722sewers
shears93820902shears
sheens95116992sheens
sheer84726892sheer_
sheets93918502sheets
shewers134312052shewers
shiers94921752shiers
shoers94518332shoers
shyers124712202shyers
sieurs659042sieurs
singers83824702singers
sinkers113618542sinkers
sinners74019022sinners
sinters74024082sinters
sivers95324152sivers
sizers155215812sizers
skeens103912912skeens
skees95023122skee_s
skeets104513252skeets
skewers14498382skewers
skiers104713702skiers
sleeks104512462sleeks
sleeps83913322sleeps
sleets64318872sleets
smears84714432smears
smeeks12428432smeeks
snarers74216662snarers
snares65329032snares
sneakers12308642sneakers
sneaks104312492sneaks
sneaps84510862sneaps
snecks124410032snecks
sneds65715352sn_eds
sneered83113972sneered
sneerer73512312sneerer
sneerers8309802sneerers
sneesh945892sneesh
sneeze15318522sneeze
sneezers17246142sneezers
sneezes16278502sneezes
sneezy18345272sneezy
snells64614202snells
snipers93311772snipers
snorers74313802snorers
snores64324322snores
snyes85012752snye_s
sobers85218862sobers
sonders83820712sonders
sowers94923442sowers
spears84019472spears
speeds94316052speeds
speels85116392speels
speer74623902speer_
speirs85013232speirs
spewers124210662spewers
spiers84421742spiers
steeds73814882steeds
steeks103613702steeks
steels64117982steels
steeps85215192steeps
steer55423862steer_
steres63929532steres
subers85722642subers
suers55128482s_uers
sunders84120052sunders
supers84622402supers
swears94114072swears
sweeps114110512sweeps
sweer84918572sweer_
sweets94214432sweets
veers84521362_veers
veneers103710292veneers

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.326548131.9
2DLD Change Limit825511282.61031628.7
3Display Results1281280.0333878.8
 (SQL Overall)1786911282.96960185.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.