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

121 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
hewers12371527(None) 
chewers154111131chewers
ewers86018821_ewers
heders104119761heders
hewer115719931hewer_
hexers165612751hexers
sewers94719711sewers
shewers134312041shewers
beers75628392be_ers
bowers115523702bowers
brewers123811052brewers
ceders93817672ceders
chawers154412032chawers
cheders134512392cheders
cheers114518912che_ers
chewer145512612chewer_
cowers114625532cowers
deers64930522de_ers
defers105116942defers
deters74724682deters
dewars105117072dewars
dowers104523292dowers
egers65120372_egers
ewer77523982_ewer_
ewes76328702_ewe_s
eyers86521332_eyers
fevers125414892fevers
fewer115216122fewer_
halers94926912halers
haters94930392haters
havers124721482havers
hawkers174210332hawkers
hawsers13409482hawsers
hayers124415942hayers
hazers184615952hazers
headers113819392headers
healers104319462healers
heapers123616672heapers
hearers104319782hearers
hears86737372he_ars
heaters104225212heaters
heavers133717192heavers
hebes105521672hebe_s
heder95623632heder_
hedgers124310252hedgers
heeders114213742heeders
heeds95420422he_eds
heelers103815622heelers
heels85625532he_els
hefters134312002hefters
heifers1337932heifers
heirs85618562he_irs
hellers103619832hellers
helpers123311852helpers
hemes105031082heme_s
hemmers143310842hemmers
herders113914122herders
heres86245902here_s
hers75844872h__ers
hetero9312632hetero
heteros10312682heteros
hewed125619432hewe_d
hews105631572hew__s
hexer155116682hexer_
hexes155123042hexe_s
hiders104919652hiders
hikers135014352hikers
hirers94518062hirers
hoers85724922h_oers
homers114821972homers
honers94324972honers
hopers114222972hopers
hosers95223952hosers
hovers124320252hovers
howes114730262howe_s
howlers133312352howlers
hypers144811912hypers
jeers124818132je_ers
jewels16508612jewels
leers54828982le_ers
legers74518312legers
lepers84817322lepers
levers94621322levers
lowers94624922lowers
meters85625832meters
mewlers12288982mewlers
mowers113219402mowers
newels93710822newels
newer85717462newer_
pawers114818782pawers
peers75130272pe_ers
peters86624592peters
pewees11311392pewees
pewters124113352pewters
powers113822322powers
refers93921082refers
revers94529632revers
rewears102911032rewears
reweds104412302reweds
rewets94617212rewets
rowers94924572rowers
sawers94620162sawers
seders74420282seders
seers55136382se_ers
severs94121122severs
sewars94018622sewars
sewer84426212sewer_
sheers94322402she_ers
shewer124515102shewer_
showers134612662showers
skewers14498372skewers
sowers94923432sowers
spewers124210652spewers
tawers94118602tawers
thawers13428482thawers
towers94423672towers
veers84521362ve_ers
vexers165210402vexers
viewers1337172viewers
vowers124317182vowers
webers11310942webers

Search took 3 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.1231452772.4
2DLD Change Limit825511212.73630172.1
3Display Results1211210.0462630.4
 (SQL Overall)1786911212.90561511.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.